Forum Discussion

JKoivu's avatar
JKoivu
Helper I
5 years ago
Solved

Simple calcuation behaves oddly

Hi, I have a measure DAX similar to this example: Distance exceeded = VAR distance = MAX(MyTable[Distance from previous]) VAR maxDistance = [Max distance] VAR fraction = distance / maxDistance ...
Need Help
  • JKoivu's avatar
    JKoivu
    5 years ago

    Hi. Yes my issue is resolved, the reason was that there was a very obvious calculation error in my measure, which I failed to notice due to time pressure. Also the reason I was getting weird values for the calculation was because I put this measure in a table (for debugging purpose), and that messed up the context. So basically my whole question is not really valid...

amitchandak's avatar
amitchandak
Super User
5 years ago

JKoivu , You need to correct your return statement

 

Distance exceeded =
VAR distance = MAX(MyTable[Distance from previous])
VAR maxDistance = [Max distance]
VAR fraction = distance / maxDistance
RETURN if( fraction > 1,[fraction]+1,[fraction])