Forum Discussion
Problems with "If" formula
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
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
Thanks that helped a lot.
But now I have another problem.
The formula [MTTR DIC] mentioned above its affected by a filter I create, so, when I change the filter, "A3" should change too because this one depends on [MTTR DIC] but it doesnt change.
How can I fix that?
Thanks Amigo