cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Card to reflect event price more than zero

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!

 

payingpatrols_powerbidax.PNG

 

1 ACCEPTED SOLUTION
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
Community Support
Community Support

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.

View solution in original post

Super User III
Super User III

use Countrows() with a value filter. 

 

Patrols or patrons?

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors