Forum Discussion

RanHo's avatar
RanHo
Helper V
4 years ago
Solved

Need help - PowerBi ( Measure base on Classification)

Good day Guys!  I have a problem here wherein im going to get this Output:  claim date - file date = SLA DAYS If the AMOUNT and SLA Days meet the category then it will PASSED otherwise it will...
Need Help
Show and Tell
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi RanHo ，

    In your snapshot above, if the CLASS column is calculated based on the amount compare with Table 2, then the CLASS of FILES NO 800001 should be C, as its amout is above 150K, and its remarks should be failed.

    Here's my solution.

    Method1

    REMARKS =
SWITCH (
    TRUE (),
    'Table'[CLASS] = "A"
        && 'Table'[SLA DAYS] = 1, "PASSED",
    'Table'[CLASS] = "B"
        && 'Table'[SLA DAYS] IN { 2.3 }, "PASSED",
    'Table'[CLASS] = "C"
        && 'Table'[SLA DAYS] IN { 3, 4, 5 }, "PASSED",
    "FAILED"
)

     Method2

    REMARKS2 = 
SWITCH (
    TRUE (),
    MAX ( 'Table'[AMOUNT] ) < 50000
        && 'Table'[SLA DAYS] = 1, "PASSED",
    MAX ( 'Table'[AMOUNT] ) >= 50000
        && MAX ( 'Table'[AMOUNT] ) <= 150000
        && 'Table'[SLA DAYS] IN { 2.3 }, "PASSED",
    MAX ( 'Table'[AMOUNT] ) > 150000
        && 'Table'[SLA DAYS] IN { 3, 4, 5 }, "PASSED",
    "FAILED"
)

    I attached my sample bellow to help you understand.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.