Forum Discussion

Tea_Programmer's avatar
Tea_Programmer
Frequent Visitor
2 years ago

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

 

 

Need Help

2 Replies

  • Tea_Programmer's avatar
    Tea_Programmer
    Frequent Visitor
    2 years ago

    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