Forum Discussion
Summarize Measures Into One Column
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
Hi TCavins ,
You cannot use measure to create tables or column into your model. Measures are context based and only calculated at the time you call them. This means that if you want to calculate the sum of a value using the slicers and filters the calculation is made.
Calculated columns are row based and the context is of the table they are.
What is the purpose of this table that you are creating? is to have the visualization of those measure in a single column on the same visualization
If this is the purpose use a matrix and then on the options turn on the Show on Rows that will create a matrix but the measures will be presented on rows as you can see below:
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?