COUNTROWS FILTER MAX AND STRING

joshua1990 — Thu, 16 Jan 2020 15:15:52 GMT

Hello everybody!

I need to calculate the number of rows where the max row of column "State" has the value "Mount" in column "Process".

So, the table has the following structure

Order	Date	State	Process
100	01.01.2019	50	Drilling
100	01.01.2019	60	Mount

My actual approach is the following:

=CALCULATE(COUNTROWS(table1);FILTER(table1;table1[Process]="Mount");FILTER(table1;table1[State]=....

Re: COUNTROWS FILTER MAX AND STRING

az38 — Fri, 17 Jan 2020 10:16:02 GMT

Hi joshua1990

try a measure

Measure = var _maxState = calculate(MAX('Table'[State]);ALL('Table'[State])) RETURN CALCULATE(COUNTROWS('Table');ALL('Table');'Table'[State]=_maxState;'Table'[Process]="Mount")

do not hesitate to give a kudo to useful posts and mark solutions as solution

topic COUNTROWS FILTER MAX AND STRING in DAX Commands and Tips

COUNTROWS FILTER MAX AND STRING

Re: COUNTROWS FILTER MAX AND STRING