Forum Discussion

David_1970's avatar
David_1970
Frequent Visitor
8 years ago
Solved

Help with calculated column

I have a table with the 3 first columns and want to calculate the fourth column. Which DAX-function?   Client Parent Client Client Responsible Parent Client Responsible 1 1 A C 2 1 ...
Need Help
  • afzalphatan's avatar
    afzalphatan
    8 years ago

    Oops , mistake in copying the formula... corrected... you can check now

     

afzalphatan's avatar
afzalphatan
Icon for Resolver I rankResolver I
8 years ago

hi David_1970

 

Hope the below formula does ur job

 

=
Var ParClientNo = Table1[Parent Client]
Var RefNo = CALCULATE(MAX(Table1[Client]), FILTER(Table1, Table1[Parent Client] = ParClientNo))
Return
CALCULATE(DISTINCT(Table1[Client Responsible]), FILTER(Table1, Table1[Client] = RefNo && Table1[Parent Client] = ParClientNo))

 

thanks