Trouble with IF Function

[Anonymous]

Hi All, 

I am trying to create a calculated measure that would assign a value of 1 (if true), and 0 (if false). 

My IF function is not returning the info in my graph data when i try to create this measure. A screenshot is attached, i am trying to give a value of 1 if Danger Zone > Days Coverage. 

I am trying to do: In Danger ? = If([danger zone]>[Days Coverage],1,0) or something similar. It won't let me bring in danger zone or days coverage. I have looked into creating a column as well. 

[JarroVGIT · Accepted solution]

Hi @Anonymous ,

Can you please post some sample data or at the very least your datamodel structure? You show picture of a table visual, a visual that typically aggregates values. If this is the original datasource, or you want this to be a measure, you might try

Measure = IF(SELECTEDVALUE(Table[Danger Zone], 0) > SUM(Table[Days Coverage]), 1, 0)

CalculatedCOlumn = IF(Table[Danger Zone] > Table[Days Coverage], 1, 0)

Let me know if this helps

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂