Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
hi,
I wanted use DAX, but, definitely, this is the solution. thanks a lot @olgad it has worked.
hi,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |