Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago
Solved

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.

2 Replies