Reply
bcbuckley13
Helper III
Helper III
Partially syndicated - Outbound

How do I get count of "Yes" from this new created Dax column?

@Ibendlin created this column for me that calculates whether stores have 2+ Champion badges. I'm trying to get a count of the number of "Yes", but a simple Countrows isn't working.
 
Two Champions equals
var c = CALCULATE(COUNTROWS('Badges'),ALLEXCEPT('Badges','Badges'[Store ID]),'Badges'[Badge Name]="Champion")
return if(c>1,"Yes","No")
 
This was created in Dax, so it's not on my main table. Can I still get a count of the "Yes" from it?
1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Syndicated - Outbound

Hi @bcbuckley13 

There's 2 answers to this.  There are actually 5 Yes in the Two Champions column

twoch.png

If you want that then create a mesure like this

 

Yes Count = CALCULATE(COUNTROWS('Badges'),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))

 

 

But if you want a distinct count of store ID's with a Yes then use this - the answer is 2

Yes Count = CALCULATE(DISTINCTCOUNT('Badges'[Store ID]),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
PhilipTreacy
Super User
Super User

Syndicated - Outbound

Hi @bcbuckley13 

There's 2 answers to this.  There are actually 5 Yes in the Two Champions column

twoch.png

If you want that then create a mesure like this

 

Yes Count = CALCULATE(COUNTROWS('Badges'),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))

 

 

But if you want a distinct count of store ID's with a Yes then use this - the answer is 2

Yes Count = CALCULATE(DISTINCTCOUNT('Badges'[Store ID]),FILTER('Badges', 'Badges'[Two Champions] = "Yes" ))

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


PhilipTreacy
Super User
Super User

Syndicated - Outbound

Hi @bcbuckley13 

Can you please provide some sample data.

regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Syndicated - Outbound

Hi  @bcbuckley13,

 

You could directly put the column in a table field >choose "count" or "discount",and you will see the value you need:

v-kelly-msft_0-1615172010687.png

Check the .pbix file attached if needed.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)