Forum Discussion
Post ProdigyNeed help with Measure
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?
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 |
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
1 Reply
- Pragati11
Super User
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