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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.