Forum Discussion

mluanacruz's avatar
mluanacruz
Icon for Helper I rankHelper 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)

     

mluanacruz's avatar
mluanacruz
Icon for Helper I rankHelper I
2 years ago

Hi, thank you so much for the answer,
I am getting this error: "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed."

 

Do you know how can I modify the measure to fix this issue? Thanks again

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi mluanacruz ,

 

How about this?

MEASURE =
DIVIDE (
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[EXPOSURE_ID] ),
        FILTER (
            'Table',
            ( [NOL to 1st BI offer] <= 30
                || [NOL to payment] <= 30 )
                && ( [ATTY_REP_IND] = "N" )
        )
    ),
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[EXPOSURE_ID] ),
        FILTER ( 'Table', [ATTY_REP_IND] = "N" )
    )
)

 

Best Regards,

Stephen Tao

 

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