Show measure only to relevant value in Row

Questions & Answers
,
1

Hi,
I created the calculated measure “CR NPS Detractor” that basically filter only the value of the Detractor option, this is my definition:

Sum(
  {[Customer NPS Rating].[Detractor]},
  [Measures].[Issues created]  
)

Screen Shot 2022-05-19 at 1.29.35 PM

Why is it showing the number also for the other options? Is there a way to show it just to the relevant option on the Rows?
Daniel

2

@Daniel_Luevano
That is because the new measure is ignoring the Customer NPS Rating completely.
It would show same results for any table row

In your case, you would need a more advanced formula

CASE WHEN
[Customer NPS Rating].CurrentMember.Name = "Detractor"
THEN
Sum((
  [Customer NPS Rating].[Detractor],
  [Measures].[Issues created]  
))
END

This formula would now be calculated only for one specific row in your report - row where Customer NPS Rating dimension member name is “Detractor”

Martins / eazyBI

3

Looks good @martins.vanags, but now how can I do to show also the totals on ‘All Customer NPS Ratings’?

image
image1848×382 48.5 KB

4

@Daniel_Luevano
Try this code

CASE WHEN
[Customer NPS Rating].CurrentMember.Name = "Detractor"
THEN
Sum((
  [Customer NPS Rating].[Detractor],
  [Measures].[Issues created]  
))
WHEN
[Customer NPS Rating].CurrentMember.Name = "All Customer NPS Ratings"
THEN
Sum([Measures].[Issues created] )
END

Martins / eazyBI

5

Hi @martins.vanags
Why don’t we add this feature to the product to automatically display the calculated measure for each row by applying all of the filter criteria that exists on that row?

6

Hi! How did you calculate the NPS score? Did you do the calculation inside of eazyBI?

7

@NadineArnold
It looks like “Customer NPS Rating” is a dimension imported in eazyBI rather than calculated field in MDX.

Martins / eazyBI