Forum Discussion

joaquinel's avatar
joaquinel
Helper I
3 years ago
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 o...
Need Help
  • olgad's avatar
    olgad
    3 years ago

    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 ")
olgad's avatar
olgad
Resident Rockstar
3 years ago

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