Matrix multiple columns and different value

[vazmor]

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

[v-jiascu-msft · Accepted solution]

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] ) )

Best Regards,

Dale

[darwindat]

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!

[vazmor]

Thank You.