Need help with Measure

HI gauravnarchal ,

I am not sure about why you are using COALESCE in your measure. You can just use DISTINCTCOUNT to get the count of distinct values in a column. Something like below:

uniqueProduct = 
DISTINCTCOUNT(
              'Supermarket Sales'[Product line]
             )

And this given me perfect distinct count at my end:

On the left my slicer shown all the distinct values in my column.

On the right I have moved the measure to a card visual to show the correct distinct count on the product column.

I am not able to understand what you mean by this:  I am getting the desired result but the total is incorrect.

Add more details please.

Thanks,

Pragati