Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Beginner question - IF statement

Hi!  Im totally new to BI since our company has moved from Tableau recently.  I work at customer service and I need to set up a calculation to show our Service Level %. We have two brands where...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

For your specifc problem though, depending how you want to do it, you could do a calculated column with DAX like this

 

IF (
    AND( 'dwh_fact d_brand'[BRAND_NAME_NEW]= "Lensway" , 'dwh_fact f_css_data'[WAIT_TIME_IN_QUE] >90), 0 ,
    IF(
        AND('dwh_fact d_brand'[BRAND_NAME_NEW] = "Lenson" , 'dwh_fact f_css_data'[WAIT_TIME_IN_QUE] >120) ,0
        ,1)
)

 

 

Your average might look like this, but would very depending on scope. For instance, if you want to keep your average wait time within each brand your DAX will look similar to this

 

CALCULATE(AVERAGE([YourCalculatdColumn],ALLEXCEPT('dwh_fact d_brand'[BRAND_NAME_NEW]))