Filter a measure using value from another slicer

[nelalx]

Hello ,

I am trying to filter the value of a card with the selectedvalue from a slicer. 

I have a slicer using the country field whose value I obtain by using selectedvalue. I am then trying to create a measure which calculates the distinctcount of deviceid from devicedetails using the below DAX.

Measure = CALCULATE(DISTINCTCOUNT(devicedetails[DeviceId]),FILTER(devicedetails,devicedetails[DCountry]=[selectedvalue]))

But i am always getting back blank in the visual. Can someone please help me fix this? Also by default when no selection is made in slicer, selecyedvalue measure also does not have a value. How can i handle this scenario ?

Kindly help me. 

[nelalx]

Many thanks for the suggestion..

[djurecicK2]

Hi @nelalx ,

 Not sure you need to do this. What happens if you just create a measure with Distinctcount of device id and put that in your visual. Does the measure value change when county slicer changes?

[nelalx]

Actually i am facing a more complex issue and I tried this as a solution. The below is my relationships. 

I am trying to find the unique deviceids when a slicer of country from the country field is applied. The devicedetails table also has a country field named DCountry, but i am not able to filter the value. Hence i tried to capture the value from slicer which uses the country field from country table and apply it on devicedetails table. 

I am able to get it to work now , it looks like the country field in devicedetails table had some spaces. a trim helped it. But can you pleasse tell me how to handle the default case. I mean if no value is selected in slicer, i am having the card shown as blank.

[djurecicK2 · Accepted solution]

What do you want to show if nothing is selected in the slicer?

You could use an if statement and hasonevalue to determine if the slicer has a single selection. If it doesn't, then return whatever default value you want.

https://learn.microsoft.com/en-us/dax/hasonevalue-function-dax

You could also try using chiclet slicer (download the visual) and force a selection in the slicer so it is never blank.