Forum Discussion

ckolahi's avatar
ckolahi
Frequent Visitor
4 years ago
Solved

Divide rows (calculated column) with different parameters

Hi Guys   I have the table below. The idea is to create a calculated column (in blue) to represent Actuals (A) vs Budget (B), for each month, quarter, product, reps etc..   Any ideas Thanks   ...
DAX
divide
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ckolahi

     

    Please try this code

    Desired =
    var maxamt=calculate(max(Feuil2[Value_SIP]),ALLEXCEPT(Feuil2,Feuil2[Names],Feuil2[Measure SIP],Feuil2[Month],Feuil2[Year]))
    return
    divide(Feuil2[Value_SIP],maxamt,0)
ckolahi's avatar
ckolahi
Frequent Visitor
4 years ago

Anonymous 

 

super thanks it works. However I think y example was misleading. What would be if the B value was not the Max value ? 

 I tried to create variable actuals (A) vs (B) with FILTER function, was not successful.

If any ideas please feel free.

Thanks