Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
7 years ago

Add another Condition

 

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 

 

 

Tutorial Requests

6 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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's avatar
      Chanleakna123
      Post Prodigy
      7 years ago

       

      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