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 community,
I am looking for a solution based on below screenshot. Is it possible to create a subtotal row only for "KPI_A" for each region with the given table structure?
Source:
Region | Company | KPI | Value |
A | CompA | KPI_A | 1 |
A | CompA | KPI_B | 2 |
A | CompB | KPI_A | 11 |
A | CompB | KPI_B | 12 |
A | CompC | KPI_A | 21 |
Thank you.
Solved! Go to Solution.
You could create a custom layout. This blog post explains how to do it for columns, but you could apply the same method for rows.
How to create a custom or hybrod matrix
I've also attached a file which has an example of a custom layout with two levels in the columns.
Proud to be a Super User!
Paul on Linkedin.
I would imagine you are going to need a SUMX() or SUMX(SUMMARIZE( )) to get the correct total
Proud to be a Super User!
Paul on Linkedin.
You could create a custom layout. This blog post explains how to do it for columns, but you could apply the same method for rows.
How to create a custom or hybrod matrix
I've also attached a file which has an example of a custom layout with two levels in the columns.
Proud to be a Super User!
Paul on Linkedin.
Thanks for the example @PaulDBrown. I will have to take a closer look at this.
In the meantime I managed to create a KPI that sums up "KPI A" so that I can show the correct value in the matrix.
However, the grand total value is now wrong (obviously).
Is there a way with DAX to show all the values but exclude some row values for the calculation of the total value?
If I just use the Calculate function with filter option and exclude the KPI "Total KPI A" it will create the correct grand total but it will also not display the amount for that row.
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 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |