Forum Discussion

kapildua16's avatar
kapildua16
Icon for Helper I rankHelper I
1 year ago

Tableau Filter Logic in Power BI DAX

Hi Power BI Community, I'm working on replicating a Tableau calculation and filter logic in Power BI using DAX, and I could use your expertise. Here's the scenario: Current Implementation in Tablea...
Need Help
Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi kapildua16 ,

 

This Calc_Premium_IQR measure:

Calc_Premium_IQR = 
[Calc_Premium_Q3] - [Calc_Premium_Q1]

 

Calc_Premium_Lowerbound measure

Calc_Premium_Lowerbound = 
IF(
    [Calc_Premium_Q1] - [Calc_Premium_IQR] * 1.5 < 0,
    0,
    [Calc_Premium_Q1] - [Calc_Premium_IQR] * 1.5
)

 

Calc_Premium_Upperbound measure

Calc_Premium_Upperbound = 
IF(
    [Calc_Premium_Q3] + [Calc_Premium_IQR] * 1.5 < 0,
    0,
    [Calc_Premium_Q3] + [Calc_Premium_IQR] * 1.5
)

 

Calc_Premium measure

Calc_Premium = 
VAR MinRateByClient =
    ADDCOLUMNS(
        SUMMARIZE(
            'Plan',
            'Plan'[Country],
            'Plan'[ClientID],
            'Plan'[Producttype],
            'Plan'[PlanDesignYear]
        ),
        "MinRate", MIN('Plan'[Premium_Min])
    )
RETURN
    AVERAGEX(MinRateByClient, [MinRate])

 

Outlier Check measure

Outlier_Check_Measure = 
VAR CalcPremium = [Calc_Premium]
VAR LowerBound = [Calc_Premium_Lowerbound]
VAR UpperBound = [Calc_Premium_Upperbound]
RETURN
IF(
    CalcPremium >= LowerBound && CalcPremium <= UpperBound,
    "Valid",
    "Outlier"
)