Count based on criteria

[jackj]

I have what I believe is a very simple problem but for some reason I can't quite solve it.  I have a measure that is calculating the total sales, all time, by store location:

DBA          Total Sales

Store 1      $1,000

Store 2      $975

Store 3      $850

Store 4      $625

Store 5      $980

I want to create a card that shows the count of locations that have total sales >$975.  How can I do this?  Thanks in advance for any help on this!

[samdthompson · Accepted solution]

Hello, this should swork:

[Jihwan_Kim · Accepted solution]

Hi, @jackj 

Please check the below.

Please put the below measure into the card visualization.

Stores Count >975 =

CALCULATE (

COUNTROWS ( 'Table' ),

FILTER ( 'Table', CALCULATE ( SUM ( 'Table'[Total Sales] ) ) > 975 )

)

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[samdthompson · Accepted solution]

Hello, this should swork: