Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Tea_Programmer
Frequent Visitor

Create column subtotals with measures

Hello,

I have this matrix table with the follow measures (Perm, Non Perm, Total):

Tea_Programmer_1-1698079732316.png


Matrix table configuration:

Tea_Programmer_2-1698079767093.png


Measures calculation:

Measure Perm =
CALCULATE(
    COUNT('Report'[Number]),
    FILTER('Report', 'Report'[Permanent / Non Permanent] = "Permanent")
)

 

Measure Total = CALCULATE(COUNT('Report'[Number]))


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:

Tea_Programmer_3-1698080396659.png

Thank you

 

 

2 REPLIES 2
Tea_Programmer
Frequent Visitor

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

amitchandak
Super User
Super User

@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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.