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

[bcbuckley13]

@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?

[PhilipTreacy · Accepted solution]

Hi @bcbuckley13 

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

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

[PhilipTreacy]

Hi @bcbuckley13 

Can you please provide some sample data.

regards

Phil

[bcbuckley13]

@PhilipTreacy

https://www.dropbox.com/sh/acyg7obojt4688j/AAD970BGhs4aPvOcbp2jR4-Pa?dl=0

[v-kelly-msft]

Hi  @bcbuckley13,

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

Check the .pbix file attached if needed.

Best Regards,
Kelly

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