Recreate formula from JS calculation to power bi report

Hi tgfauzan9303 ,

We can try to create a calculated column to meet your requirement:

Restriction =
VAR CharLocal =
    FIND ( ";", [event.target.id] )
VAR Column0 =
    LEFT ( [event.target.id], CharLocal )
RETURN
    SWITCH (
        Column0,
        "wrhwr_eot_overdue.total_generated", "wrhwr_eot_overdue.status_generated = '1' AND ",
        "wrhwr_eot_overdue.total_open", "wrhwr_eot_overdue.status_open ='1' AND ",
        "wrhwr_eot_overdue.total_complete", "wrhwr_eot_overdue.status_complete='1' AND ",
        "wrhwr_eot_overdue.total_overdue", "wrhwr_eot_overdue.status_overdue='1' AND ",
        "wrhwr_eot_overdue.total_eot", "wrhwr_eot_overdue.status_eot='1' AND "
    )

If it doesn't meet your requirement, Could you please provide a mockup sample based on fake data or describle the fields of each tables and the relations between tables simply? It will be helpful if you can show us the exact expected result based on the tables. Please upload your files to OneDrive For Business and share the link here.

Please don't contain any Confidential Information or Real data in your reply.

Best regards,