How to allow measure value change with filters?

[Penn]

Hi all,

A very simple question. I have the measure below

Opp. # EOM Order Placed = CALCULATE(DISTINCTCOUNT('EOM Opp'[Opportunity ID]), 'EOM Opp'[EOM Stage] = "Order Placed", DATESBETWEEN('EOM Opp'[EOM Date], MIN('Calendar'[Date]), MAX('Calendar'[Date])))

And a column chart like this

I am quite confused here as I choose "Assessment" in the slicer, shouldn't the measure value shown on the bar chart be empty? As it is set to look at "Order Placed" only. How can I adjust to let nothing show up on the bar chart?

Thanks.

[v-juanli-msft]

Hi

Is this problem sloved? 

If it is sloved, could you kindly accept it as a solution to close this case?

If not, please let me know.

Best Regards

Maggie

[v-juanli-msft · Accepted solution]

Hi @Penn 

Which column is added into the "Axis" of the bar chart?

Could you show a simple data example for analysis?

If you want your measure only to show values when 'EOM Opp'[EOM Stage] = "Order Placed",

Create a measure

measure =
IF (
    SELECTEDVALUE ( 'table'[EOM Stage] ) = "Order Placed",
    [Your measure],
    BLANK ()
)

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Bar Chart Labels are not visible. But if you are looking data by EOM stage, then you should see the only bar for that; and if choose other value you should no see data. 

[Penn]

Hi @amitchandak

If you look at the screenshot I provided, I chose "Assessment" in the filter but the measure which is supposed to show only "Order Placed" still shows data. How can I resolve this?