Forum Discussion

felipevaz's avatar
felipevaz
Icon for Helper I rankHelper I
6 years ago

Distinct Count If Rows are duplicate in certains conditions

Hi folks,   Please, I have a table like this   Category1 Client A 1 B 1 B 2 A 3 A 4 B 4   Distinct Count of Client 4   Distinct Count of Client only if Categor...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi felipevaz 

Distinct Count of Client=DistinctCount(table[Client])

 

 

Distinct Count of Client only if Category1 has different values=Sumx(Summerize(table,table[Client],"Count",DistinctCount(table[Category1])),if([Count]>1,1,0))

 

Drag above measures in seperate card visuals.

 

Thanks & regards,
Pravin Wattamwar
www.linkedin.com/in/pravin-p-wattamwar

If I resolve your problem Mark it as a solution and give kudos.

 

 

  • felipevaz's avatar
    felipevaz
    Icon for Helper I rankHelper I
    6 years ago
    Thank you Wattamwar

    It works well, but when I need to filter the Category1 the measure does not represent the right behavior. Like, if I select Category1 = A the measure does not distinct count the cases.

    May I use booth cases in the same measure?
    Distinct count Client by A cases OR
    Distinct count Client by B cases OR
    Distinct count Client by AB cases OR
    Distinct count Client independently