Categorizing measures
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
