Slicer is ignoring visual level filters

[Jcoat64]

I'm working on a survey dashbpoard for my hospital and have run into an issue. I have four charts using the same measure (NPS_Scorce) but each chart has a visual level filter set to based on the question being asked. I have a slicer basexd upon the department being selected. When I don't have a department selected the charts show different data, but when I select a department in the slicer, all the charts switch to showing the same data points. It appears the slicer is ignoring the viusal level filter? Any thoughts?

******************************

NPS_Score =

VAR TotalCount = COUNTROWS('NRC_RT_TABLE')

VAR PromoterCount = CALCULATE(COUNTROWS('NRC_RT_TABLE'), 'NRC_RT_TABLE'[OUTREACHATTEMPT_NPSCATEGORY] = "Promoter")

VAR DetractorCount = CALCULATE(COUNTROWS('NRC_RT_TABLE'), 'NRC_RT_TABLE'[OUTREACHATTEMPT_NPSCATEGORY] = "Detractor")

RETURN

(DIVIDE(PromoterCount, TotalCount, 0) - DIVIDE(DetractorCount, TotalCount, 0)) * 100

************************************

[Anonymous]

Thanks for lbendlin's concern about this issue. 

Hi, @Jcoat64 

I am glad to help you.

This problem may occur because the Slicer visual selection overrides the visual level filter and so causes all charts to show the same data.

Perhaps you could try modifying the DAX to the following:

NPS_Score =
VAR TotalCount = COUNTROWS('NRC_RT_TABLE')
VAR PromoterCount = CALCULATE(COUNTROWS('NRC_RT_TABLE'), 'NRC_RT_TABLE'[OUTREACHATTEMPT_NPSCATEGORY] = "Promoter", ALLSELECTED('NRC_RT_TABLE'[Department]))
VAR DetractorCount = CALCULATE(COUNTROWS('NRC_RT_TABLE'), 'NRC_RT_TABLE'[OUTREACHATTEMPT_NPSCATEGORY] = "Detractor", ALLSELECTED('NRC_RT_TABLE'[Department]))
RETURN
(DIVIDE(PromoterCount, TotalCount, 0) - DIVIDE(DetractorCount, TotalCount, 0)) * 100

Use ALLSELECTED to ensure that the Department Slicer is taken into account when calculating the NPS_Score.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

That works as designed. Visual level filters only impact that particular visual.