Need help with Measure

[gauravnarchal]

I have created the below measure to distinct count the column "ProfileNameGroup". I am getting the desired result but the total is incorrect. How can I modify this measure to show the correct total?

Meaure - Count = COALESCE(DISTINCTCOUNT(ClientGroupMaster[ProfileNameGroup]),0)

Table  - ClientGroupMaster

ProfileNumber	ProfileName	ProfileNameGroup
1	Test Ltd	ADC Group
2	Btech Ltd	ADC Group
3	CID Ltd	ADC Group
4	BLE Ltd	ADC Group
5	GEM LTG	DEF Group
6	CDS LTD	DEF Group
7	BEF LTD	DEF Group
8	GLC LTD	DEF Group
9	QWA LTD	DEF Group
10	OPL LTD	GEH Group
11	POL LTD	GEH Group
12	GEL LTD	GEH Group

[Pragati11 · Accepted solution]

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