Forum Discussion
Solved
DAX
Hi, I'm new to DAX and I'm struggling to understand the following: I have two columns in the same table: CID (a unique card ID) UID (a unique user id) I want to evaluate all instances where...
Hi Andy6001 ,
Suppose this is your sample table.
To display those records where each unique UID has more than one CID and count the number of UID which meets such a condition, please refer to below measures:
count CID = IF ( CALCULATE ( DISTINCTCOUNT ( Sheet9[CID] ), ALL ( Sheet9[CID] ) ) > 1, CALCULATE ( DISTINCTCOUNT ( Sheet9[CID] ), ALL ( Sheet9[CID] ) ), BLANK () ) Count UID = IF ( [count CID] = BLANK (), BLANK (), CALCULATE ( DISTINCTCOUNT ( Sheet9[UID] ), FILTER ( ALLSELECTED ( Sheet9 ), [count CID] > 1 ) ) )Best regards,
Yuliana Gu
Hi Andy6001 ,
Suppose this is your sample table.
To display those records where each unique UID has more than one CID and count the number of UID which meets such a condition, please refer to below measures:
count CID =
IF (
CALCULATE ( DISTINCTCOUNT ( Sheet9[CID] ), ALL ( Sheet9[CID] ) ) > 1,
CALCULATE ( DISTINCTCOUNT ( Sheet9[CID] ), ALL ( Sheet9[CID] ) ),
BLANK ()
)
Count UID =
IF (
[count CID] = BLANK (),
BLANK (),
CALCULATE (
DISTINCTCOUNT ( Sheet9[UID] ),
FILTER ( ALLSELECTED ( Sheet9 ), [count CID] > 1 )
)
)
Best regards,
Yuliana Gu