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 ...
Tutorial Requests
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 

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

      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