Group values of a column into two groups

[Quinnie2017]

You would think by now I would know how to do this but alas I have struck out.  Can you help?

Trying to group the values in column "Popeyes" into two groups: >0 and 0.

Expected values for Count of Stores

>0 = 247

0 = 739

Popeyes file here 

What is the DAX to do this?

[Quinnie2017]

@TheoCThank you!

[TheoC · Accepted solution]

Hi @Quinnie2017 

You can create a calculated column as follows:

Column = SWITCH ( TRUE () , 'Table'[Popeyes] = 0 , 739, 247 )

Basically, the formula says, if Popeyes column = 0 then return 739, otherwise, return 247 for everything else.

Also, make sure that you have Popeyes column set to Whole Number and not Text.

Hope this helps 🙂

Theo