PowerBi - Counting Switch Statements

[obriaincian]

Hi All,

I have the following measure:

test = SWITCH(TRUE(),
MAX(test[month])>=9&&MAX(test[month])<=12,"fall",
MAX(test[month])>=1&&MAX(test[month])<=3,"winter",
MAX(test[month])>=4&&MAX(test[month])<=6,"spring",
MAX(test[month])>=7&&MAX(test[month])<=8,"summer")

Currently it looks at the month number (i.e. "3" for March and outputs "winter", what I'd like however is it to output is a count per season to show the distribution of the seasons in the dataset.

For example my desired output would be

Month Number	Count of occurrences of each season
fall	5
winter	7
spring	9
summer	11

I can't have a calculated column here either as I will want to make this measure dynamic later on with the use of a slicer, can someone tell me if this is possible?

[v-jingzhang · Accepted solution]

Hi @obriaincian 

You can first add a table with season values in it. Just like below.

Then create the following measure to count the occurrences. [test] is your original measure. 

Measure = COUNTX(FILTER(test,[test]=SELECTEDVALUE(Seasons[Season])),test[month])

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[obriaincian]

exactly what I was looking for, thanks

[amitchandak]

@obriaincian , You can create a table with these values and join that with a measure in filter using table or values/summarize in a new measure

refer to the example. In place of a numeric table, you need a text table

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ