Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.
Hello,
I have this matrix table with the follow measures (Perm, Non Perm, Total):
Matrix table configuration:
Measures calculation:
How can I create a measure with these requirements:
- Sum all the permanents of the year and when I use in the matrix table keep the sum for the row values.
- When I add this new measure in matrix table show in the Quarter level instead of Row Labels.
- I could use the column subtotals feature but every time I filter by quarter in the slicer the Totals change automatically.
Expected output example:
Thank you
Hi, @amitchandak
I'm new in Power BI and I didn't understand the video example.
How can I use a measure in the top level of column like the example mentioned (Total column -> Perm Column (Count all Perm)).
Could you give an example for this situation?
Thank you
@Tea_Programmer , You can use isinscope to switch measure at sub sub-total level
How to Switch Subtotal and Grand Total in Power BI | Power BI Tutorials| isinscope: https://youtu.be/smhIPw3OkKA
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
78 | |
76 | |
70 | |
49 | |
42 |
User | Count |
---|---|
62 | |
40 | |
32 | |
30 | |
29 |