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

Preparing for a certification exam? Ask exam experts all your questions on May 15th. Register now.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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