Categorizing measures

[Anonymous]

Hi all,

I am kind a new to the PowerBI world, so forgive me for perhaps a silly question. 

For work I am currently building a billability analysis in PowerBI. I would like to summarize all the necessary numeric fields on the "overview" tab, filtered by department. Since this also includes information from another Table, I created measures for this. By using the measures as values (and switched columns to rows), it looks like this:

Now I want to group the certain measures into categories, so I can drill down/expand on different levels and make subtotals. In other words, I want to f.e. group the "Parental leaves"and "workable days"under "total available hours". As you can see, I tried to make a measure of this, but it does not have the wanted outcome (see yellow marked row above).

How I want it to look like, is for example my Excel version of this report:

You guys will be my hero's if you can help me out! 🙂

Kind regards,

Paul

[Anonymous]

Hey Ada,

First of all, thanks for your response. 

The output of the current measures is calculated with a calculate and sum function, on 2 databases: 1 which contains the registered hours and 1 which containts the parental leaves. The registered hours are mapped through an additional table and linked in the model. 

The question is the following: how can I map/catogorize the different measures, so I can make some kind a hierarchy? This way, I can make subtotals and expand/close certain measures to summarize them to a subtotal (like in the last printscreen). 

I am not what information you are looking for :(. Mainly because I dont know in which direction to think right now.

[Anonymous]

Hi @Anonymous ,

Based on your question, can you explain how your desired output was calculated. If you do not mind could you also provide some detailed data (without sensitive information), providing specific data and clearly expressing the results you want can help us better understand your problem.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.