Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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    
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hey Anonymous 

         

        If my other post solved your initial question please accept it as the solution.

         

        For your next question. I'm not sure I entirely understand. Where is the filtering happening?

         

        Suggestions:

        You can either use the FILTER function in your formula: https://docs.microsoft.com/en-us/dax/filter-function-dax

        Or the LOOKUPVALUE function to lookup the value for the "A3" vaiable based on the filter: https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax

         

        LOOKUPVALUE functions much like vlookup in excel.