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

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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hey Anonymous 

         

        The measure [MTTR DIC] depends on variable call "ZONA".

         

        Now, like you helped me, I create a calculated column like this:

         

        A3 = IF([MTTR DIC]>[META MAX MTTR];1;0)                                            ([META MAX MTTR] is a column of datas)

         

        But the problem is than I can´t modify the datas of A3 with the filter like i do with  [MTTR DIC], although both (A3 and  [MTTR DIC]) depends  on "ZONA".

        I put some pictures below for better understanding