Forum Discussion
More than function
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...
Hello Anonymous ,
You can try this.
Total Tickets =
CALCULATE ( COUNT ( 'table'[Tickets] ), SUM ( 'table'[eventprice] ) > 0 )