Need help with Dynamic Grouping
Consider that there are different categories –
I have a checkbox where one can select the categories. –
If user selects Extra small and small, rest categories should be grouped to other.
Can someone help me to write DAX for dynamic grouping?
Thank you in advance.
Go to Solution.
@weicaomis123 , If it based on another column, you can create a new column, using Switch
If you need on the measure you need to binning or segmentation
refer video: https://youtu.be/CuczXPj0N-k
Proud to be a Super User!
View solution in original post
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
all measures are in the sample pbix file.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.Linkedin: https://www.linkedin.com/in/jihwankim1975/
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.