Forum Discussion
Responsive ResidentMeasure does not honor filter from other visuals
Hello everyone!
I have the following measure for Discrepancy Current Month
Thank you for helping out!
Abhinav
That was my original question and you made it super complicated to answer. Change your measure to this
DiscrepancyCount =CALCULATE(DISTINCTCOUNT('TableName'[ID-Name]),keepfilters('TableName'[Match] <> "TRUE"))
7 Replies
- parry2k
Super User
That was my original question and you made it super complicated to answer. Change your measure to this
DiscrepancyCount =CALCULATE(DISTINCTCOUNT('TableName'[ID-Name]),keepfilters('TableName'[Match] <> "TRUE")) - parry2k
AbhinavJoshi where are you using this measure?
AbhinavJoshiparry2k thanks for looking into it. I am using this measure in my gauge visual
- parry2k
AbhinavJoshi what you want the gauge to show when you click on other visuals? It will be blank, correct?
- AbhinavJoshi
Hi, if I click on the Match Type false or not in ABC, it should reflect the discrepancy count for those categories or filter values coming from that pie chart.
- parry2k
AbhinavJoshi if you click on type false, and your measure is saying show true only in the gauge, what do you expect at that time? In my opinion, it will be blank, or maybe I'm not following what you are trying to achieve here.
- AbhinavJoshi
Hello parry2k. When I click on the Match Type -> True, The discrepancy count should be zero. When I click on False it should show the discrepancy count of Match Type false and so on for others. Currently it is not taking any filters coming from the Pie Chart. Thanks for looking into it!