Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello Community,
I have two column in data set which is in below.
I create one slicer with Taster name. with multiple selection. Suppose i select as and ks.
i want distinct count of uniqueID which both taster.
i want 2 answer. one id is 100 and 102
Unique ID | Taster |
100 | as |
100 | ks |
100 | ds |
101 | as |
101 | ds |
102 | as |
102 | ks |
102 | ds |
102 | as |
Solved! Go to Solution.
@Dhrutivyasa-070
Apologies for the late response and for misunderstanding the requirement. Please refer to attached sample file file with the proposed solution.
Count =
SUMX (
VALUES ( 'Table'[Unique ID] ),
INT (
ISEMPTY (
EXCEPT (
VALUES ( 'Table'[Taster] ),
CALCULATETABLE ( VALUES ( 'Table'[Taster] ) )
)
)
)
)
Thank You very Much tamerj1.
Its Working Properly.
I try same this bus i get anwser is 3.
i want only this unique id which contains both as and ks
@Dhrutivyasa-070
Apologies for the late response and for misunderstanding the requirement. Please refer to attached sample file file with the proposed solution.
Count =
SUMX (
VALUES ( 'Table'[Unique ID] ),
INT (
ISEMPTY (
EXCEPT (
VALUES ( 'Table'[Taster] ),
CALCULATETABLE ( VALUES ( 'Table'[Taster] ) )
)
)
)
)
Thank You very Much tamerj1.
Its Working Properly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
10 | |
7 | |
6 | |
6 |
User | Count |
---|---|
17 | |
14 | |
11 | |
9 | |
7 |