Forum Discussion
HitcH
Helper II
3 years agoEASY Formula not working
Hi everyone
I have two measures and I want to calculate the percentage one of the other:
I expected the value to be 79% but I get 2%. This is probably a very stupid question but it's late and I can't solve it by myself 😮
6 Replies
- Padycosmos
Solution Sage
You may try
Measure =DIVIDE(sum([first column]),sum([second column]))
- HitcH
Helper II
Wow, the value has changed, but it is not the correct one yet
- Padycosmos
Solution Sage
If the data is not sensitive could you please share the pbix file?
- Gowtham_Selvam
Resolver I
measure=DIVIDE(sum(1st & 2nd column),sum(2nd column))
If I answered your question mark it as solution.