cancel
Showing results 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

Frequent Visitor

## Create column subtotals with measures

Hello,

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

Matrix table configuration:

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:

Thank you

2 REPLIES 2
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

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

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors