Forum Discussion
Syndicate_Admin
Administrator
3 years agoHow 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 MAXIM...
- 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
Ashish_Mathur
Super User
3 years agoHi,
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.