Measure is not interacting with slicers even if the INTERACTIONS is correct

[Anonymous]

Hi Guys,

Newbie here.

I have a dataset with a column that contains different numbers and a measure that having the formula below.

NPS Score =

CALCULATE(

COUNTROWS(CCT),CCT[NPS Map]=5)

 

Whenever I am trying to filter the NPS map using slicer the measure(car) is not changing even if the interactions from the slicers to card is correct.

 

If you can see below image. I filtered NPS Map to 1 but still the CARD is showing 18 which is the total of rows that has 5 data.

 

The card result should be 0 right ?

 

[Thim · Accepted solution]

Nevermind, just found a meassure you can use.

you just need to add the filter funktion to your calculation.

NPS Score =

CALCULATE(

COUNT(CCT[NPS Map]),

FILTER(CCT,CCT[NPS Map]=5)

)

I would still concider using the filter on the matrix instead of making a Meassure, but that depends on what you need it for ofcourse. 🙂

[Anonymous]

Yeah it is gonna work however, if im gonna add another calculation on the measure like this one

test = (CALCULATE(COUNTROWS(Sheet1),Sheet1[sdsad] = 5) - (CALCULATE(COUNTROWS(Sheet1),Sheet1[sdsad] = 4)))

the result is still the same even when you select other numbers in slicers.

[Thim]

Not sure how to fix your meassure. I am guessing when doing calculation, it will disregard some filters.

However, here is a workaround for this specific issue.

Instead of making a calculation were you filter down to only count those that equals 5. You can set the filter on the Matrix itself.

Then the Matrix will also concider any other filters you have.

Hope this will help. 🙂

[amitchandak]

Can you share cal for Total Agents and table realtion diagram

[Anonymous]

There is only 1 column