Forum Discussion
Divide problem
Hi Everyone, I am trying to create one divide column. I created the Load calculated column as I need to do. Secondly, I use filter to create Pallets column. Now I want to divide the Pallets to Lo...
Anonymous , formula seems correct, Assume both Pallets and load are measures not column and the new formula is also measure
if they are column then it should be
= Divide(sum(Table[Pallets]),Sum(Table[load]))
Anonymous , formula seems correct, Assume both Pallets and load are measures not column and the new formula is also measure
if they are column then it should be
= Divide(sum(Table[Pallets]),Sum(Table[load]))
They both are calculated measure.
Anonymous , the final divide should be measure. I am not able to see your calculation. Can you post all that in text format?
Can you share sample data and sample output in a table format? Or a sample pbix after removing sensitive data.
Now is working.
Thanks
Amjad