Use an IF on a column containing string value that if it returns true, returns a number

[ChrisMcHugh]

IF(AND(AND(AND(AND(VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] = "LOADED", (VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS]) <> "PARTIALLY LOADED"), (VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS]) <> "FAILED"), (VW_STAGING_TO_ACQ_LOAD_DETAIL[TABLE_NAME]) = "ROUTES"), 0)))

This above code will not work for me as I need a function between the last AND and VW_STAGING_TO_ACQ_DETAILS. Any function I use does not wield the correct results

[Samarth_18]

Hi @ChrisMcHugh ,

If I took your question correctly then I think you could try below code:-

IF (
    VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] = "LOADED"
        && VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] <> "PARTIALLY LOADED"
        && VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] <> "FAILED"
        && VW_STAGING_TO_ACQ_LOAD_DETAIL[TABLE_NAME] = "ROUTES",
    0
)

BR,

Samarth

[ChrisMcHugh]

Hi Samarth,

Yes it is along those lines for definite. However, upon trying your code, this is the error I am getting.

Is there any way to work around this as I am directly pulling from a column in a dataset

[ChrisMcHugh]

@themistoklis 

It is in a column yes

[Samarth_18]

@ChrisMcHugh Please update it as:-

IF (
    MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] ) = "LOADED"
        && MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] ) <> "PARTIALLY LOADED"
        && MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[LOAD_STATUS] ) <> "FAILED"
        && MAX ( VW_STAGING_TO_ACQ_LOAD_DETAIL[TABLE_NAME] ) = "ROUTES",
    0
)

[ChrisMcHugh]

Hi @Samarth_18 upon further investigation, I realised this is not quite the solution as it does not return the true value for me, essentially what I have is set it to 0 and then I have formatted a button so that if the measure is 0, to colour the button green yet it is leaving the colour blank and when I set 0 as the false expression also, it then colours the button, I do not think it is reading the max correctly, I am unsure though

[Samarth_18]

@ChrisMcHugh you could break down the measure and return the required value, to check if we are getting expected values or not. or you could share your PBIX file after removing sensitive data.

[ChrisMcHugh]

Hi @Samarth_18 Yes I have broken down the measure and only set one condition on it in an attempt to return the desired outcome but no luck as of yet

[v-easonf-msft]

Hi, @ChrisMcHugh 

If the problem persists, please provide your demo for further research.

Best Regards,
Community Support Team _ Eason

[ChrisMcHugh]

Yes it seems to be working to some extent! I will have to nest IF and IFELSE for different conditions but the basics of it are correct, thank you