Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |