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)

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Kaviraj11 's formula is great.

 

And I found countd means count the unique number of rows, it is more recommended that you use DISTINCTCOUNT function, mluanacruz .

Measure = 
DIVIDE(
    CALCULATE(
        DISTINCTCOUNT('Table'[EXPOSURE_ID]),
        'Table'[NOL to 1st BI offer] <= 30 || 'Table'[NOL to payment] <= 30,
        'Table'[ATTY_REP_IND] = "N"
    ),
    CALCULATE(
        DISTINCTCOUNT('Table'[EXPOSURE_ID]),
        '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.

 

 

mluanacruz's avatar
mluanacruz
Helper 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.