Forum Discussion

TCavins's avatar
TCavins
Helper V
5 years ago
Solved

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. ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi TCavins ,

     

    you can add the categories on the rows of the matrix visualization and the information will be presented has you need:

     

     

    Second inmage is turning off the stepped layout.

  • Anonymous's avatar
    Anonymous
    5 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

Anonymous's avatar
Anonymous
Not applicable
5 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