Forum Discussion

mkinal's avatar
mkinal
Regular Visitor
6 years ago

Assign string value based on multiple criteria

Hi Guys,   I have four related tables: - masterdata_ragwear: stores article information, one side - article_states: stores one kind of status of articles, one-to-one relation to masterdata_ragwea...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

If the only issue is not checked in is not working. I think because others are numeric

 

Motive Status = 
VAR selectedAid =
SELECTEDVALUE(masterdata_ragwear[aid])
VAR mStatus =
SWITCH(
    TRUE(),
        ISBLANK([Production Status]),
        "Not checked in",
        
        ISBLANK([Retouch Status]),
        [Production Status] & "",

        [Retouch Status] & ""
)
RETURN
CALCULATE(mStatus, selectedAid=article_filenames[aid])

 

but this will make data type as text

  • mkinal's avatar
    mkinal
    Regular Visitor
    6 years ago

    Hi amitchandak ,

     

    Thanks for the quick reaction! Unfortunetely this isn't solving my problem. All measures should return value type text, so I don't think that's the problem.

     

    The problem I have is how to return values (but keep filter context) when the return value is empty. I'd like to list all items from masterdata_ragwear (based on filter context) and display all statuses (including blanks) for them.