It me??? Why different outcomes? Calculations with Measures, Columns and HArdcoded

[gazzo1967]

Hi All
Why when i hard code a number in to a measure

for example BN PASSED% = SA_Full[BN count passed]/159*100
the outcome is as expected
but when i use a measure in place of the 159 where the measuee is the same number it changes the outcome?

regards Gary

[Idrissshatila · Accepted solution]

HEllo @gazzo1967 ,

try this:

BN PASSED% =
Var passed = Divide(SA_Full[BN count passed],secondmeasure,0)
return
passed * 100

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡