Forum Discussion

Pbiuserr's avatar
Pbiuserr
Icon for Post Prodigy rankPost Prodigy
4 years ago

Help with measure

Hello,

Could anyone tell me why this measure gives me same result as just normal sum, the threshold of 1.5 doesnt work (this field is a calculated column to which DIVIDE was used and its reflected in pct, but 150% is 1.5, right?)

 

Measure =

VAR _First_Amount = CALCULATE( SUM( Table[Amount] ), 'FactTable'[Ratio] <= 1,5 )
VAR _Second_Amount = CALCULATE( SUM( Table2[Amount] ), 'FactTable'[Ratio] <= 1,5 )
RETURN
CALCULATE( DIVIDE( _First_Amount, _Second_Amount ))

Need Help

4 Replies

  • Syk's avatar
    Syk
    Icon for Resident Rockstar rankResident Rockstar
    4 years ago

    First thing I see is that your measure has 1,5 (comma) instead of 1.5 - could that be the issue?

    • Pbiuserr's avatar
      Pbiuserr
      Icon for Post Prodigy rankPost Prodigy
      4 years ago

      Hello,

      No. I tried last approach with coma, but it gave me error. I am trying with dots

      • Syk's avatar
        Syk
        Icon for Resident Rockstar rankResident Rockstar
        4 years ago

        Can you share some of your data? Also I'm not sure if you changed the variable names to post here but they don't match your return in the measure.