cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to show a measure only in some rows

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).

 

 PTwithMeassure.png

 

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?.

 

 PTwithMeassureOpened.png

 

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

 

 MyMeasure.png

 

Thanks in advance.

 

Milton

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

Answer.png

 

Kind regards.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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.

 

Answer.png

 

Kind regards.

Abduvali
Skilled Sharer
Skilled Sharer

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

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors