Forum Discussion
TCavins
5 years agoHelper V
Summarize Measures Into One Column
I have a slicer on a Date table named Dates. The date table is not linked to anything, it is just used to help populate the values of various measures used in another table, currently called Query2. ...
- Anonymous5 years ago
HI TCavins,
As MFelix said, measures are content-based expressions.
If you use them to calculate column/table, their row contents will be fixed and not dynamically calculated with row contents and correspond filter effects.For your requirements, you can create an attribute table with all measure names.
Then you can use this new field on matrix row, use a measure expression to replace the raw value field to return correspond results based on current category values.My Favorite DAX Feature: SELECTEDVALUE with SWITCH
Regards,
Xiaoxin Sheng
TCavins
5 years agoHelper V
It's closer to what I want.
Category 1
Measure 1 12
Measure 3 18
Category 2
Measure 1 13
Anyway to now split the measures into a column next to the Category and totals after that?