Forum Discussion

mluanacruz's avatar
mluanacruz
Helper I
2 years ago
Solved

Help! Tableau measure into power Bi

Hi everyone, Can someone please help me transforme this Tableau measure into Power Bi? Tableau: countd(if ([NOL to 1st BI offer] <= 30 or [NOL to payment] <= 30) and [ATTY_REP_IND]='N' then [E...
Need Help
  • Kaviraj11's avatar
    Kaviraj11
    2 years ago

    Hi,

     

    Try this out:

     

    CombinedRatio =
VAR Numerator =
    COUNTROWS(
        FILTER(
            'YourTableName',
            ([NOL to 1st BI offer] <= 30 || [NOL to payment] <= 30) && [ATTY_REP_IND] = "N"
        )
    )
VAR Denominator =
    COUNTROWS(
        FILTER(
            'YourTableName',
            [ATTY_REP_IND] = "N"
        )
    )
RETURN
DIVIDE(Numerator, Denominator)