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
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