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