Data Formatting

[CNovak]

Hi,

Thought I've taken a starter course in Power BI, I'm mostly self taught and dont have many if any resources to turn to for help with this. This is likely an incredibly basic question, but please bear with me! I've had a look online for an answer, but I'm drawing a blank at the moment.

I'm looking to build up some tables that display how much time is spent on a given grouped activity and what proportion of the total time that represents (the below example filtered for admin tasks). I dont know if it's how I've constructed the measure, but I'm struggling with the additional rows that appear (marked in yellow) when I add the "Actuals %" measure into the table. I imagine it's the table looking to present all possible grades that exist for each worker option, but I can't understand why it's looking to do that. 

For reference, I'd created the measure as:

Actuals % = format(calculate (sum('Summary'[Hours])) / calculate( sum('Summary'[Hours]) , all ('Summary'[Grouping])) , "00.0%")

Is there some formatting option I'm missing that would remove this issue?

Any help would be appreciated!

Thanks

Chris

[CNovak · Accepted solution]

Finally figured out what I've been missing and it is embarassingly simple.

Sharing here on the chance that someone else is as blind as I am and overlooks the Filters section. Essentially, it was right there and I just needed to select for the column to show entries where there are non blanks.