Forum Discussion

JRowe's avatar
JRowe
New Member
4 years ago
Solved

Distinct Count with AND

I need to write a dax measure that tells me how many ID's there are with email AND mobile. There is a row of data for each Contact detail, so each ID has multiple rows. Therefore I would need a disti...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi JRowe 

    for a card visual please try > New measure

    ID Count (E & T) =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            TableName,
            TableName[ID],
            "E&T", SUM ( TableName[Email] ) * SUM ( TableName[Mobile] )
        ),
        [E&T] > 0
    )
)
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi JRowe 

for a card visual please try > New measure

ID Count (E & T) =
COUNTROWS (
    FILTER (
        SUMMARIZE (
            TableName,
            TableName[ID],
            "E&T", SUM ( TableName[Email] ) * SUM ( TableName[Mobile] )
        ),
        [E&T] > 0
    )
)
JRowe's avatar
JRowe
New Member
4 years ago

tamerj1 that's really brilliant and worked perfectly. I was having trouble putting on filters that accounted for both email and mobile, so great solution