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 is what I attached but I repeat the information in each column and not That's what I'm looking for, additionally there is a slicer that selects the brand.

Archive Sample

 

Thank You

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

3 Replies

  • 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!