Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello All,
Kindly need help on the below situation.
I have a duplicate numbers in Table1 and i need to create measure for Distinct value.
I am using this in measure
Check your table relationship is it one to many OR many to many, the mapping column should not be a duplicate value s
Hello Dangar,
Thanks for your response.
I need the value of Distinct
Eg
Table1
0
0
0
1
1
1
3
3
3
I need as
0
1
3
hi, @krishak77
i suggest you to make new table using
distinctcount =
and now you can make table visual or any visuals like these
and yah, don't forgot to change to check below
here i am use different value so don't confuse
Did i answer your question? Mark my post as a solution which help other people to find fast and easily.
Hello Dangar,
Actually i have did the same thing, but i have some categories in another table and when i do filter results are not getting change.
Even though i link the relation for both the table.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
30 | |
11 | |
11 | |
10 | |
6 |