DAX

[Dhrutivyasa-070]

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

[tamerj1 · Accepted 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] ) )                
            )
        )
    )
)

[tamerj1]

HI @Dhrutivyasa-070 
You can simply try

DISTINCTCOUNT ( 'Table'[Unique ID] )

[Dhrutivyasa-070]

I try same this bus i get anwser is 3.

i want only this unique id which contains both as and ks

[tamerj1 · Accepted 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] ) )                
            )
        )
    )
)

[Dhrutivyasa-070 · Accepted solution]

Thank You very Much tamerj1.
Its Working Properly.