Forum Discussion
Problems with "If" formula
Hi
The problem is than i can´t use the formula "IF" when i am trying to compare a measure i create and a column.
I´m new in Power BI
No Problemo mi amigo. Mi espanol es mal, pero Google Translate works lol. That error is usually due to trying to create a measure instead of a calculated column. Check out the link below:
https://community.powerbi.com/t5/Desktop/Measure-single-value-cannot-be-determined/td-p/65612
If you were trying to create another measure, you will likely need to create a calculated column instead.
If this helps please give Kudos
If this fixes your problem please accept it as a solution
7 Replies
Hey Anonymous
Can you post a copy of your formula?
Some ideas:
Make sure you are using proper syntax.
If you are referencing other tables make sure to use the correct syntax for referencing other tables as well.
If your measure result and column are in different formats you may have to use the FORMAT function to get them to compare properly.
The formula i am using is the next:
A3 = IF([MTTR DIC]>[META MAX MTTR];1;0)Where [MTTR DIC] is a measure and [META MAX MTTR] is colmumn of datas.The error is:"No se puede determinar el valor para 'META MAX MTTR'. Puede que 'META MAX MTTR' no exista o que actualmente no haya ninguna fila para la columna 'META MAX MTTR'." Is in spanish, sorry.No Problemo mi amigo. Mi espanol es mal, pero Google Translate works lol. That error is usually due to trying to create a measure instead of a calculated column. Check out the link below:
https://community.powerbi.com/t5/Desktop/Measure-single-value-cannot-be-determined/td-p/65612
If you were trying to create another measure, you will likely need to create a calculated column instead.
If this helps please give Kudos
If this fixes your problem please accept it as a solution