Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Desptached])
Thanks,
PV
Solved! Go to Solution.
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]
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
Hi Mohit,
Hope you're doing well.
I need one more help please. Example of data given below and would like to find out below queries using dax.
Find out distinct count order no.s whatever cases/units desp and excludes 0 (Zeros).
Find out Line no.s whatever cases/units desp and excludes 0 (Zeros).
Hope you can understand my queires. If not, please let me know.
I look forward to hear from you.
Thanks
PV
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]
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
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |