Forum Discussion
Super UserSLICER NOT ABLE TO CHANGE DAX OUTPUT
Hi PowerBI Community,
I have a simple query here ,
With the DAX expressions below ideally the KPI number should change with the slicer selection but it remains constant at 570,all the values are coming from the same table
Other card visuals look ok though
Has anyone faced similar situation?
Not sure what is this issue since I don't have any problem with sample superstore
Regards,
Ritesh
Hi ribisht17 I dealt with a lot of similar situations, and all of them were caused by logic problems of dax measures.
IF slicer does not affect visuals, which means there is a lack of needed relationship/context between them.
This can come from using All/Allselect/Allexept ...etc functions.
(In terms of defining interactions and your card's relationship with the slicer, everything is fine.
And Slicer should filter the card).Unfortunately, beyond these general things, I cannot guess anything without feeling the model and the indicators, at least at my level of knowledge 😞
4 Replies
- Ritaf1983
Hi ribisht17
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523- Ritaf1983
Hi ribisht17 I dealt with a lot of similar situations, and all of them were caused by logic problems of dax measures.
IF slicer does not affect visuals, which means there is a lack of needed relationship/context between them.
This can come from using All/Allselect/Allexept ...etc functions.
(In terms of defining interactions and your card's relationship with the slicer, everything is fine.
And Slicer should filter the card).Unfortunately, beyond these general things, I cannot guess anything without feeling the model and the indicators, at least at my level of knowledge 😞
- ribisht17
Thanks Rita, I appreciate your answer inspite of data not being added, I will try to replicate the scenario and upload again
