Selection returns value even when number of selections outside of parameter

[DW868990]

Hi,

I have the below measure:

Sales (Return when 2 selected only) =

VAR CountryCount = CALCULATE(DISTINCTCOUNT(Sales[Country]), ALLSELECTED(Sales[Country]))

VAR Result = IF(CountryCount = 2, [Sales], BLANK())

RETURN

Result

Now i need this measure to return values only for when 2 items are selected in the slicer, however when i select a 3rd item, it shows the data for the 3rd item and shows the other 2 items as blank; and in fact what i require is for the full visual to show blank when 3 items are selected.

Is there something I am missing in the DAX?

Thanks in advance.

[DW868990]

Thank you!

Worked great, with that little tweak 🙂

[amitchandak · Accepted solution]

@DW868990 , Measure seem fine to use that as the visual level filter and check for not blank

or try like

Sales (Return when 2 selected only) =
VAR CountryCount = CALCULATE(DISTINCTCOUNT(Sales[Country]), ALLSELECTED(Sales))
VAR Result = IF(CountryCount = 2, [Sales], BLANK())
RETURN
Result