Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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! 🙂
Proud to be a Super User!
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! 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |