Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.