filter by number of rows

[NigelBarrett]

I have a data model that tracks the hours people book to their timesheets.
I have a measure that filters all the ones that did not book the minimum number of hours for any week. This is called [need to fill in].
Next I have a measure that counts the number of weeks that have not been filled in fully. This is Count weeks:=countx('Calendar',[Need to fill in])
So for so good.
I have been trying to create a measure that filters [need to fill in] with [count weeks] > 1.
No joy here though.
Instead I do the filter in the pivot table itself using value filters.
Any suggestions?

 

[ExcelGzh]

Nigel

Try using COUNTIFS. This allows multiple filtering criteria.

 

[NigelBarrett]

Thanks for the suggestion but there is no COUNTIFS in DAX.
I am looking for something like COUNTROWS but that does not work on my [count weeks] measure.

 

[ExcelGzh]

OK. I didn't realise you were using DAX. Out of my area of expertise I'm afraid.

 

[C Moore]

This link takes you to SUM with two filters, should be possible to convert to count.

DAX: sum with two filters

Hi all, I am trying to make a new measure 'SalesWest' in Power BI Desktop but I can not make it work. The situation: there are two tables, Table 1 (factSales) and a related Table 2 (dimStores). Now I would like to make a measure that sums all sales where the Store = West (Lookup to...

community.powerbi.com