Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 I can use? Thanks in advance!

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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