cancel
Showing results for
Did you mean:  Helper I

## 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
1 ACCEPTED SOLUTION  Memorable Member

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 ")

Best Stories, Interesting Cases: PowerBI Storytime Newsletter
2 REPLIES 2  Helper I

I wanted use DAX, but, definitely, this is the solution. thanks a lot @olgad   it has worked.  Memorable Member

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 ")  