Forum Discussion
How to make a measure split into groups in a column
Hi, I put in context:
I have a table that has a column (done in PowerQuery) to divide by groups. Basically I use the value of two other columns, one of them we can call it TOTAL and another MAXIMUM. Basically to make this column I make 4 ranges with conditionals: If my TOTAL is greater than 0 but less than MAXIMUM/4 I call it " GROUP 1"; If my TOTAL is greater than MAXIMUM/4 but less than (MAXIMUM/4)* 2 I call it " GROUP 2"; If TOTAL is greater than (MAXIMUM/4)* 2 but less than (MAXIMUM/4)* 3 it is called " GROUP 3"; and finally if TOTAL is greater than (MAXIMUM/4)*3 it is called "GROUP 4".
The new column is created and the groups are divided based on the value of the total correctly. Then, I have taken that column to a graph, to the option of small multiples so that I get the 4 ranges. And now what I need is to use an independent measure that I have and have it show me the value of that measure for each of those ranges, that is, how much it is worth for GROUP 1, GROUP 2, etc ...
But the difficulty is that the measure is not related, it is a measure that is made by operating two other measures and in turn others, etc ... Is there a way to do what I ask? Because if I put the measure as it is, it shows me the value of my equal measure for all ranges.
Here's a screenshot of how it's currently displayed:
Thanks a lot.
- Anonymous3 years ago
HI Anonymous ,
You can create a new table with all groups and use it as source of visual axis, then you can write formula to check current value and navigate to different formulas.
Regards,
Xiaoxin Sheng
2 Replies
- AnonymousNot applicable
HI Anonymous ,
You can create a new table with all groups and use it as source of visual axis, then you can write formula to check current value and navigate to different formulas.
Regards,
Xiaoxin Sheng
- Ashish_Mathur
Super User
Hi,
Since you have derived the Groups via a calculated column formula, you can create a slicer of the Group column and select a specific group. If your measure is well written, the result of the measure should recalculate when a slicer selection is changed.