Forum Discussion

vazmor's avatar
vazmor
Helper II
8 years ago
Solved

Matrix multiple columns and different value

Hello I need to do the following table, with the first column must be the total brand, but in the following columns that works as a matrix and calculate each brand individually, what I have so far i...
Need Help
Tips and Tricks
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi vazmor,

     

    The workaround is using a calculated column instead of a measure. Please give it a try.

    All Brand column =
CALCULATE ( SUM ( Hoja3[Sale_Value] ), ALLEXCEPT ( Hoja3, Hoja3[Store] ) )

    Matrix_multiple_columns_and_different_value

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi vazmor,

 

The workaround is using a calculated column instead of a measure. Please give it a try.

All Brand column =
CALCULATE ( SUM ( Hoja3[Sale_Value] ), ALLEXCEPT ( Hoja3, Hoja3[Store] ) )

Matrix_multiple_columns_and_different_value

 

Best Regards,

Dale

darwindat's avatar
darwindat
Helper I
6 years ago

Hi v-jiascu-msft ,

That's a brilliant workaround. 

Now I have an extra question. What if I want to have the similar column like "All brand collumn", but this column value should change based on my slicer selection. As I understand, Calculated column cannot be changed based on slicer/filter (filter context), only Measures can be changed. But Rows (in Matrix setting) does not accept Measures (I tried to drag the measure into the Rows, it didin't allow).
Do you know any other workaround to solve my issue?

Thank you very much!