Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply

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 both taster.

i want 2 answer. one id is 100 and 102

Unique IDTaster
100as
100ks
100ds
101as
101ds
102as
102ks
102ds
102as

 

2 ACCEPTED SOLUTIONS

@Dhrutivyasa-070 
Apologies for the late response and for misunderstanding the requirement. Please refer to attached sample file file with the proposed solution.

1.png

Count = 
SUMX ( 
    VALUES ( 'Table'[Unique ID] ),
    INT (
        ISEMPTY ( 
            EXCEPT ( 
                VALUES ( 'Table'[Taster] ),
                CALCULATETABLE ( VALUES ( 'Table'[Taster] ) )                
            )
        )
    )
)

View solution in original post

Thank You very Much tamerj1.
Its Working Properly.

View solution in original post

4 REPLIES 4
tamerj1
Super User
Super User

HI @Dhrutivyasa-070 
You can simply try

DISTINCTCOUNT ( 'Table'[Unique ID] )

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.

1.png

Count = 
SUMX ( 
    VALUES ( 'Table'[Unique ID] ),
    INT (
        ISEMPTY ( 
            EXCEPT ( 
                VALUES ( 'Table'[Taster] ),
                CALCULATETABLE ( VALUES ( 'Table'[Taster] ) )                
            )
        )
    )
)

Thank You very Much tamerj1.
Its Working Properly.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors