How to show a measure only in some rows

[Anonymous]

Hello... I need your help. I've tried to solve but I could not.

I need to show a measure (% Respect Revenue) in some rows into a Pivot table (Operating Expense and EBITDA)... until this part I could do it as I show you in the first image (Operating Profit (before D&A) showing a measure in blank).

 

When I open the content of Non-Personel show the items into it, and each one show the % Respect Revenue (Red rectangles). But We need in this point that only show blank and the % Respect Revenue appear only into the subtotal (Green rectangle) as I show you in the second image. Is this possible?.

 

Finally, I've attached an image with the measure in order to give you a best idea of our data.

 

Thanks in advance.

Milton

[Anonymous · Accepted solution]

Thanks @Abduvali for the idea however it doesn't work for our data.

However, after many intents, I resolved it. I've to use a new measure with the function HASONEVALUE as is showing in the next image, if someone is interest in this case.

Kind regards.

[Abduvali]

Hi @Anonymous,

I think the problem you have is derived from the way you calculated [All Revenue] measure I believe it's a sum of all revenues (non-personnel + personnel...etc) so if you calculate your Non-Personnel in separate measure then it will be blank, try something like this maybe it will work for you:

• Non-Personnel = calculate(sum(YourTableName[Sales]),YourTableName[Department] = "Non-Personnel"))

Regards

Abduvali