Forum Discussion

obriaincian's avatar
obriaincian
Resolver I
4 years ago
Solved

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[mon...
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

amitchandak's avatar
amitchandak
Super User
4 years ago

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