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

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: How to show a measure only in some rows

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
Abduvali Skilled Sharer
Skilled Sharer

Re: How to show a measure only in some rows

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

Highlighted
Anonymous
Not applicable

Re: How to show a measure only in some rows

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors