Distinct Count If Rows are duplicate in certains conditions

Hi felipevaz 

Something like this should do what you want:

Distinct Count of Client only if Category1 has different values = 
COUNTROWS ( 
    FILTER ( 
        VALUES ( YourTable[Client] ),
        CALCULATE ( DISTINCTCOUNT( YourTable[Category1] ) ) > 1
    )
)

Regards,

Owen

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.

Let me reintroduce the question...also include a new dimension here to better explains the context

The distinct count has to change if the dimensions are filtered, like

Case 1) Distinct count of Client = 4

Case 2) Distinct count of Client in 01/01/2020 = 3

Case 3) Distinct count of Client that has both A and B category = 2

Case 4) Distinct count of Client in 01/01/2020 that has both A and B category = 1

I need to measure the distinct count if Category1 has no filter, if the Client has A and B or if the Client has A OR B value...

Can it be done in one measure?? Using diferent dimensions?

Sorry my english, it is not thaaat good.