Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Trouble with IF statement

Hi all,

 

Fairly new to Power BI and DAX so I was hoping someone might be able to help me out here. I'm currently trying to create an IF statement using a field and it's not co-operating. The field is in the screenshot below, it's basically a list of job titles - I want the IF statement to say something along the lines of 

 

if(Rate[JobTitle]="AccountsPayable" && Rate[Pay_Rate]<=15.83,15.79, 15.00, BLANK)
 
However, the IF statement only appears to accept Measures and won't allow me to input JobTitle as a field. Could someone help explain to me why this is, and perhaps how I can work around it?
 
My first instinct was that I was required to create a calculated column, but as I am connected directly to a database my understanding is that this is not possible.
 
Thannks so much!

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    My test table:

     

    Please try below steps:

    1.Create a measure

    Measure =
VAR cur_jobtitle =
    MAX ( 'Rate'[JobTitle] )
VAR cur_payrate =
    MAX ( 'Rate'[Pay_Rate] )
RETURN
    IF ( cur_jobtitle = "Accounts Payable" && cur_payrate <= 45, 15.79, 15.00 )

    2.Visualize data with table visual

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Jos_Woolley's avatar
    Jos_Woolley
    Icon for Solution Sage rankSolution Sage
    4 years ago

    You could try the following measure:

    MyMeasure =
VAR ThisJobTitle =
    MIN( 'Rate'[JobTitle] )
VAR ThisPayRate =
    MIN( 'Rate'[Pay_Rate] )
RETURN
    IF(
        ThisJobTitle = "AccountsPayable"
            && ThisPayRate <= 15.83,
        "Return This",
        "Return That"
    )

    Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    My test table:

     

    Please try below steps:

    1.Create a measure

    Measure =
VAR cur_jobtitle =
    MAX ( 'Rate'[JobTitle] )
VAR cur_payrate =
    MAX ( 'Rate'[Pay_Rate] )
RETURN
    IF ( cur_jobtitle = "Accounts Payable" && cur_payrate <= 45, 15.79, 15.00 )

    2.Visualize data with table visual

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.