Forum Discussion
Post ProdigyAdd another Condition
Microsoft Employee
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
Post Prodigy
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
- Chanleakna123
- v-cherch-msft
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