Calculate number of months over target

[Arete]

I'm having a brain fart and can't figure out how to create a measure to count the months over a target. 

Measure that shows %: 

2022 Margin % = 
DIVIDE(
    [2022 Total Amount Converted] - [2022 Total Costs], [2022 Total Amount Converted]
)

I'd like to create a measure that counts months that are over 50% (.5).

[vicky_ · Accepted solution]

You can use a var for your DIVIDE calculation and return if > 0.5. 

Something like:

2022 Margin % = 
var counts = DIVIDE(
    [2022 Total Amount Converted] - [2022 Total Costs], [2022 Total Amount Converted]
)
return IF(counts > 0.5, counts, BLANK())

[Arete]

Thank you, very helpful!