Forum Discussion
felipevaz
Helper I
Helper IDistinct 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...
felipevazHelper I
Helper IPravin,
The function
values=Sumx(Summerize(table,table[Client],"Count",DistinctCount(table[Category1])),if([Count]>1,1,0))
is returning 2 if the "Client" has "A" and "B" values at the same time.
But this is not the total number of distinct Clients...is 4
| Category1 | Date | Client |
| A | 01/01/2020 | 1 |
| B | 02/01/2020 | 1 |
| B | 01/01/2020 | 2 |
| A | 02/01/2020 | 3 |
| A | 01/01/2020 | 4 |
| B | 01/01/2020 | 4 |
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?
Where are you applying measure?
Is it in card or table itself?
And where are applying filter
Is it in slicer ?
If you are taking date column in slicer and the measures in card..value of measure will change with selected date in slicer.
I hve given two measures one is for distinctcount of clients.
Other one is distinctcount of clients have both a and b.
Both measures value will get change with filteres.
Thanks
Pravin
Is it in card or table itself?
And where are applying filter
Is it in slicer ?
If you are taking date column in slicer and the measures in card..value of measure will change with selected date in slicer.
I hve given two measures one is for distinctcount of clients.
Other one is distinctcount of clients have both a and b.
Both measures value will get change with filteres.
Thanks
Pravin