Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Store "IF" condition in variable

Hi,   I'm wondering, is power bi capable to store IF conditions in a variable? example       var kondisi = 1 //using a dropdown, it will change value either 1 or 2 VAR param_kondisi = I...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , it should return true or false

 

try like

Calculate_Result =
CALCULATE(
COUNT('00. SPK'[primkey]),
KEEPFILTERS(
'Table'[client_name] = "Superman"
&& ((kondisi = 1 && 'Table'[Population 1] <> BLANK()) || (kondisi <> 1 && 'Table'[Population 2] <> BLANK()))

)
)

Anonymous's avatar
Anonymous
Not applicable
4 years ago

thanks! it returns correctly

but is there any chance that pattern as I mentioned earlier, is possible in power bi?

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , Just make sure it returns true or false

     

    like

    IF(kondisi = 1,
    if('Table'[Population 1] <> BLANK(),true(), false())
    if('Table'[Population 2] <> BLANK(),true(), false())
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      it does not return true or false, but it is returned as a condition inside the variable calculate_result

      it is returned as it was like below :

       

       

       

      Var Calculate_Result =
    CALCULATE(
        COUNT('Table'[primkey]),
        KEEPFILTERS(
            'Table'[client_name] = "Superman"
            && IF(kondisi = 1,
                 'Table'[Population 1] <> BLANK(),
                 'Table'[Population 2] <> BLANK()
               )

        )
    )

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ，

        I'm not quite sure what you want... According to the formula you provided, the result returned by the variable Calculate_Result should be a numeric value: the number of primkeys. And the formula syntax of the variable Calculate_Result is also correct. Could you please provide a simple sample data and the final result you want? Maybe we can implement your requirement in some other way later. Thank you.

        Best Regards