If statement for a percent value

[1001]

Hi All, I have a calculated column (see below) to calculate a percent from two numbers of other columns.

Now I'd like to create another column to display if the percent is greater than 70%. Just not sure how to write the DAX for it, if someone could help. Thanks. 

Greater 70% = if('ZSLED Excel'[Percent Remaining]>70%,'ZSLED Excel'[Percent Remaining],0)

[Migasuke · Accepted solution]

Hi,

In your DAX calculation do not use % sign, only use decimal version. Instead of 20% use 0.2 etc.
Example here:

[1001]

Ahh, I had .7 rather 0.7 earlier. 

Thanks Migasuke, appreciate that. Cheers.