Forum Discussion
Solved
Count unique values
hi,
I should need to count how many IdMember I have when the Account is 70810030 and there is no a movement with the Account 70510230 with the same CodPago.
In the table below it should count only the movements in black (6 movements).
Everything is in the same table. I need to use DAX, not to create another table, because my DDBB is so big.
Thanks
| IdMember | Account | CodPago | Importe |
| 340941 | 70510230 | 6570978 | 13,99 |
| 336324 | 70810030 | 6571176 | -59,99 |
| 591715 | 70810030 | 6571404 | -59,99 |
| 341593 | 70810030 | 6571751 | -56,52 |
| 349251 | 70810030 | 6572379 | -56,52 |
| 329769 | 70510230 | 6649504 | 13,99 |
| 349190 | 70810030 | 6653518 | -94,90 |
| 349190 | 70510230 | 6653518 | 94,90 |
| 634287 | 70810030 | 6685785 | -49,99 |
| 634287 | 70510230 | 6685785 | 49,99 |
| 632611 | 70810030 | 6685787 | -49,99 |
hi,
Column = Calculate(CountRows(Table),ALLEXCEPT(Table, Table[CodPago]))
Measure= Calculate(Count(Table[Columnfromabove]), Table[Columnfromabove]=1)
or if you specifically need that account then
Measure= Calculate(Count(Table[Columnfromabove]), Table[Columnfromabove]=1 &&TableAccount="70510230 ")
2 Replies
hi,
Column = Calculate(CountRows(Table),ALLEXCEPT(Table, Table[CodPago]))
Measure= Calculate(Count(Table[Columnfromabove]), Table[Columnfromabove]=1)
or if you specifically need that account then
Measure= Calculate(Count(Table[Columnfromabove]), Table[Columnfromabove]=1 &&TableAccount="70510230 ")
