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.
In my data set I need to take a count or distinct count of a unqiue ID depending on a column value. In the below example, if the Value is A or C I need to take a count of the Unique ID and if the Value is B I need to take a distinct count. The Expected Result is what I would need the data to be represented as in a single visualization. Any help would be greatly appreciated as I keep going in circles.
Data Example | |||
Value | ID | Unique ID | Count Type |
A | 12345 | A12345 | Count |
A | 12345 | A12345 | |
A | 12345 | A12345 | |
B | 13579 | B13579 | Distinct |
B | 13579 | B13579 | |
B | 54321 | B54321 | |
B | 54321 | B54321 | |
B | 97531 | B97531 | |
C | 11223 | C11223 | Count |
C | 99887 | C99887 |
Expected Result | |
Value | Total |
A | 3 |
B | 3 |
C | 2 |
Solved! Go to Solution.
Hi @pranit828 ,
I took what you provided and was able to tweak it a little to get what I needed. Here is where I ended up at when creating the measure. Thanks for the assistance.
Hi @Anonymous
Use matrix chart instead of table chart
Or
Create is as a column instead of measure.
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @pranit828 ,
I took what you provided and was able to tweak it a little to get what I needed. Here is where I ended up at when creating the measure. Thanks for the assistance.
HI @Anonymous
You can try
_count =
Switch(TRUE(),
'A',COUNT(COL),
'B',DISTINCTCOUNT(COL),
'C',COUNT(COL))
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @pranit828 ,
I am able to create a measure with the formula suggested, but when adding the measure to a visual I receive the following error "Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values."
Regards,
Eric
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |