Add another Condition

[Chanleakna123]

Hi All, 

* I have 2 tables , Table 1 is : Code , and table 2 as table above 

I linked the relationship between these 2 tables. 

i have condition as calculated as per above , and i set " Normal , Expired , High Risk as per above " , But i wanna add another "OOS" mean if the Code in Table 2 didn't appear  , it will show "OOS " while i use the Table 1 as the main , and visualize the condition in Table 2.  Because the Code in table 2 didn't appear , mean there's no QTY. 

how to success this ? 

I experienced with multiples condtion , but failed to get this . 

thanksyou 

[v-cherch-msft]

Hi @Chanleakna123

You may check below measure.

Condition Risk =
IF (
    'Master Data'[Expired in (Days)] > RELATED ( DOI[High Stock ] )
        && 'Master Data'[Code] = RELATED ( DOI[Code] ),
    "Normal",
    IF (
        'Master Data'[Expired in (Days)] <= RELATED ( DOI[HIGH Risk ] )
            && 'Master Data'[Code] = RELATED ( DOI[Code] ),
        "High Risk",
        IF (
            'Master Data'[Expired in (Days)] > RELATED ( DOI[POS Risk] )
                && 'Master Data'[Expired in (Days)] <= RELATED ( DOI[High Stock ] ),
            "Potential Expired",
            IF ( 'Master Data'[Code] <> RELATED ( DOI[Code] ), "OOS" )
        )
    )
)

Regards,

Cherie

[Chanleakna123]

Hi @v-cherch-msft Really Appreciated all your input . but look like it's in contrast of what i'm thinking . 

DoI Code table in Bi , is the main code we used , 

Master Data Code in BI is the table we key in the Data . 

My purpose is , If Master Data [Code] no Any recorded of the Code as the Main Table DoI[Code] Provided, Show" OOS ". 

Because my users will no key in Any data in there're no Quantity. then i will no , oh this Code is OOS. 

i test your calculation , look not correct . above 2483 has 45 cases in Master [ Code ] , but show OOS. 
if 2483 has 0 cases in Master Data [ Code ] which is no recorded should show OOS. 

thanks you , looking more your comment. 

Best Regards, 
Leakna 

[Chanleakna123]

@v-cherch-msft hi dear , 

any update on this ? 

Thanks you 

[Chanleakna123]

@v-cherch-msft

[v-cherch-msft]

Hi @Chanleakna123

Based on my understanding, the "OOS" should be in DOI Table as below, right? Why it should be condition in the Master Table. I'm confused.

Regards,

Cherie

[v-cherch-msft]

Hi @Chanleakna123

It seems you need compare code column with table1 and table2. Is that right? If it is not your case, please share your data sample file and explain more about your expected output. You can upload it to OneDrive or Dropbox and post the link here.

Regards,

Cherie