Forum Discussion
kapildua16
Helper I
Helper ITableau to Power BI Migration
Hi Everyone, I am working on Migrating a Tableau Project to Power BI In Tableau there is a fixed Lod name currentpremium {Fixed[Country],[ClientID]:Min([Premium])} for this i writo below dax CA...
bhanu_gautam
Super User
Super Userkapildua16 , First create a measure for
currentpremium =
CALCULATE(
MIN('Table'[Premium]),
ALLEXCEPT('Table', 'Table'[Country], 'Table'[ClientID])
)
create a measure for Calc__Q2 which calculates the 50th percentile (median) of currentpremium
Calc__Q2 =
CALCULATE(
PERCENTILEX.INC(
SUMMARIZE(
'Table',
'Table'[Country],
'Table'[ClientID],
"currentpremium", [currentpremium]
),
[currentpremium],
0.5
),
ALLEXCEPT('Table', 'Table'[Country], 'Table'[ClientID])
)
if you need to perform an average calculation on top of Calc__Q2, you can create another measure:
Average_Calc__Q2 =
AVERAGEX(
SUMMARIZE(
'Table',
'Table'[Country],
'Table'[ClientID],
"Calc__Q2", [Calc__Q2]
),
[Calc__Q2]
)