More than function

[Anonymous]

Hi Power BI community,

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!

[Anonymous]

Hello @Anonymous ,
You can try this.
Total Tickets =
CALCULATE ( COUNT ( 'table'[Tickets] ), SUM ( 'table'[eventprice] ) > 0 )