Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
i know how to count distinct values, but in our data sometime we have same ID for different users (and this is ok) and i need to distinctcount this users like two different values, f.e.: two different persons have same ID 59566 and measure shows distinctcount result 1 but i need to see 2. Is it imposible? If yes, what should i add to my measure or maybe calculate this in other way:
Solved! Go to Solution.
Hi
If your ID is not unique, i could sugest you create a Surrogate Key by concatenating the ID and the username. You can to this in either Power Query or by a Calculated Column.
This way you will have a unique ID and be able to count the distincts
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hi
If your ID is not unique, i could sugest you create a Surrogate Key by concatenating the ID and the username. You can to this in either Power Query or by a Calculated Column.
This way you will have a unique ID and be able to count the distincts
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Yes, you are right! 🙂
Thx a lot!