Count rows with measure equal to x

[_nerdy]

Hi,

I'm trying to write a new measure that returns a count of rows where an existing measure equals 1. I've tried many different approaches, the latest being:

NewMeasure = COUNTROWS(FILTER('MyTable', [MyExistingMeasure] <> 0 ))

and

NewMeasure = CALCULATE([MyExistingMeasure],FILTER(VALUES(MyTable),[MyExistingMeasure]=1))

etc.

The existing measure returns a 1 when its conditions are met or 0 when not. I am pretty sure it is working as expected as I can apply a filter to a table visual with the parameter "MyExistingMeasure is 1" and it only shows rows I'd expect to see.

I am trying to create a card that shows the total count of rows with a 1 in that measure and thought a new measure that creates the counts would be the way to go.

Stumped. Help appreciated.

Regards,

_nerdy

[amitchandak · Accepted solution]

@_nerdy , to count a measure you need a context or grouping level, Assume you have id

example measure

Countx(filter(values(MyTable[ID]) ,[MyExistingMeasure] =1), [ID])

of use visual level filter MyExistingMeasure =1

[StuartSmith]

This just helped solve my problem 😁

Thanks

[jfpalumbo]

Solved my problem too! TY!

[_nerdy]

Amazing, thank you! 😁

[ALLUREAN]

Hi, @_nerdy 

Try this:

CALCULATE(COUNTROWS('MyTable'),FILTER('MyTable', [MyExistingMeasure] = 1))