Forum Discussion
PowerBi - Counting Switch Statements
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?
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.
3 Replies
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.exactly what I was looking for, thanks
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
