Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
26 | |
20 | |
19 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
24 | |
23 | |
21 |