Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Thank You
Solved! Go to 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
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
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!
Thank You.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |