Forum Discussion

PowerBI-P's avatar
PowerBI-P
Frequent Visitor
2 years ago
Solved

DAX Calculation getting wrong

Hi all,   I've used below DAX for calculations for (O.Total Equi.Cases) and each row of calculations are right but total is wrong. Please advise.   Here O.Total Units means (Outbound[Units Despta...
Need Help
  • mohitkumawat's avatar
    mohitkumawat
    2 years ago

    Try Below one Method,

    Create a new Calculated Column 
     O.Total Equi. Cases =Outbound[Units Despatched] / Outbound[Unique SKUs.Units per Case]
    Create a new Calculated Column 
    O.Total Equi. CasesV1= [O.Total Cases]+ [O.Total Equi. Cases]

     

  • PowerBI-P's avatar
    PowerBI-P
    2 years ago

    Hi Mohitkumawat,

     

    Thank you so much for your help. It's working now and you're briliant 👌.

     

    I was spent lot of hours on this to resolve this issue and always trying to work on measures calcuations side but didn't think your way.

     

    I should have posted my query before itself but didn't realise.

     

    Once again thank you very much for your help.

     

    Thanks

    PV

mohitkumawat's avatar
mohitkumawat
Impactful Individual
2 years ago

Try Below one Method,

Create a new Calculated Column 
 O.Total Equi. Cases =Outbound[Units Despatched] / Outbound[Unique SKUs.Units per Case]
Create a new Calculated Column 
O.Total Equi. CasesV1= [O.Total Cases]+ [O.Total Equi. Cases]

 

  • PowerBI-P's avatar
    PowerBI-P
    Frequent Visitor
    2 years ago

    Hi Mohitkumawat,

     

    Thank you so much for your help. It's working now and you're briliant 👌.

     

    I was spent lot of hours on this to resolve this issue and always trying to work on measures calcuations side but didn't think your way.

     

    I should have posted my query before itself but didn't realise.

     

    Once again thank you very much for your help.

     

    Thanks

    PV