Forum Discussion
Helper IGroup values using a measure ?
psilos24
Lets say if you have a column has value from 1-200, you want to group into 4 groups. You can create 4 measures and put them in the Values section.Group 1 = Caluclate(sum([Column]),filter(Table, [column]<=50) Group 2 = Caluclate(sum([Column]),filter(Table, [column]>50&&[column]<=100) Group 3 = Caluclate(sum([Column]),filter(Table, [column]>100&&[column]<=150) Group 4 = Caluclate(sum([Column]),filter(Table, [column]>150&&[column]<=200)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It is not possible to add a measure as chart legend, as measure actually returns a single value.
As an alternative, I would suggest you create two separately measures for each group(group 1=> less than 10, group 2 = between 10-20,etc). Then add these two measures into Values section of the chart.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
psilos24Anonymous Thanks for the reply. Can you give me an example of how to create a measure for a group?
psilos24
Lets say if you have a column has value from 1-200, you want to group into 4 groups. You can create 4 measures and put them in the Values section.Group 1 = Caluclate(sum([Column]),filter(Table, [column]<=50) Group 2 = Caluclate(sum([Column]),filter(Table, [column]>50&&[column]<=100) Group 3 = Caluclate(sum([Column]),filter(Table, [column]>100&&[column]<=150) Group 4 = Caluclate(sum([Column]),filter(Table, [column]>150&&[column]<=200)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.