Tableau to Power BI Migration

bhanu_gautam - Thanks for Providing the solution but i am not getting the correct result

I am working on a calculation that involves computing the average of percentiles based on grouped data. I am able to get the correct result (16948) by creating separate DAX-calculated tables, but I am unable to achieve the same result using measures.

Here’s what I did that worked:

1. I created a table calc_currentPremium using the following DAX: Calc_currenrrate =
   SUMMARIZE(
   'Plan',
   'Plan'[Country],
   'Plan'[ClientID],
   'Plan'[Producttype],
   'Plan'[PlanDesignYear],
   "mincurrentPremium", MIN('Plan'[Currentrate_premium])
   )
   On top of this, I created another table Q2 to calculate the median:

Q2 =
SUMMARIZE(
Calc_currenrrate,
Calc_currenrrate[Country],
Calc_currenrrate[Producttype],
Calc_currenrrate[PlanDesignYear],
"Median", PERCENTILE.INC(Calc_currenrrate[mincurrentPremium], 0.5)
)

Finally, I created a measure to calculate the average of medians:

AvergareQ2 = AVERAGE(Q2[Median])

This approach gives me the correct result.

However, when I try to implement the same logic entirely as measures without creating intermediate tables, the result is incorrect

MinCurrentRate =
CALCULATE(
MIN('Plan'[Currentrate_premium]),
ALLEXCEPT(
'Plan',
'Plan'[Country],
'Plan'[ClientID],
'Plan'[Producttype],
YEAR('Plan'[PlanDesignEffectiveDate])
)
)

MedianCurrentRate =
PERCENTILEX.INC(
SUMMARIZE(
'Plan',
'Plan'[Country],
'Plan'[Producttype],
YEAR('Plan'[PlanDesignEffectiveDate]),
"MinRate", [MinCurrentRate]
),
[MinRate],
0.5
)

AverageMedianRate =
AVERAGEX(
SUMMARIZE(
'Plan',
'Plan'[Country],
'Plan'[Producttype],
YEAR('Plan'[PlanDesignEffectiveDate]),
"Median", [MedianCurrentRate]
),
[Median]
)