March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
87 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |