cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Super User

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

PROUD TO BE A SUPER USER!
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.

Super User

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

PROUD TO BE A SUPER USER!
Best Stories, Interesting Cases: PowerBI Storytime Newsletter

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors