Measure does not honor filter from other visuals

[AbhinavJoshi]

Hello everyone! 

I have the following measure for Discrepancy Current Month

DiscrepancyCount =

CALCULATE(

    DISTINCTCOUNT('TableName'[ID-Name]),

    ('TableName'[Match] <> "TRUE")

)

This measure calculates the values well but does not take any filters coming from Pie Chart or the Bar Chart. 

Thank you for helping out! 

Abhinav

[parry2k · Accepted solution]

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")

)

[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! 

[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]

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 what you want the gauge to show when you click on other visuals? It will be blank, correct?

[AbhinavJoshi]

@parry2k  thanks for looking into it. I am using this measure in my gauge visual

[parry2k]

@AbhinavJoshi where are you using this measure?