Help with measure

[Pbiuserr]

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 ))

[Syk]

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

[Pbiuserr]

Hello,

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

[Syk]

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.

[Pbiuserr]

Yes I changed due to private reasons (client data, can easily spot)

Cannot share the data unfortunately, but let me explain

Basically I got two tables with some $ amount (Table and Table2)

I want to divide sum of these, but only for lines from Fact table, where column in Fact table [Ratio] is above 150% (thus 1.5)