Forum Discussion

Dhrutivyasa-070's avatar
Dhrutivyasa-070
Helper I
3 years ago
Solved

DAX

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...
  • tamerj1's avatar
    tamerj1
    3 years ago

    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's avatar
    Dhrutivyasa-070
    3 years ago

    Thank You very Much tamerj1.
    Its Working Properly.

tamerj1's avatar
tamerj1
Community Champion
3 years ago

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's avatar
Dhrutivyasa-070
Helper I
3 years ago

Thank You very Much tamerj1.
Its Working Properly.