Card to reflect event price more than zero

[andrewtan1993]

I am trying to find the number of paying patrons/ticket (i.e. eventprice > $0) but I cannot reflect that on my card. Does anyone know how I can do that? Or what DAX formula I can use? Thanks in advance!

[Icey · Accepted solution]

Hi @andrewtan1993 ,

Just as what @lbendlin mentioned, create a measure like so:

Counts =
COUNTROWS ( FILTER ( ALLSELECTED ( 'Table' ), 'Table'[eventprice] > 0 ) )

Or this:

Counts =
CALCULATE ( DISTINCTCOUNT ( 'Table'[paying patrons] ), 'Table'[eventprice] > 0 )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[lbendlin]

use Countrows() with a value filter. 

Patrols or patrons?