Forum Discussion
Count based on criteria
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!
Hello, this should swork:
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
2 Replies
Hello, this should swork:
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