Im trying to convert an LOD expression for INCLUDE into a DAX expression.

[Diva20]

Hello All

Im trying to convert an LOD expression from Tableau and want to replicate the same in PowerBI.

Please help me out:

Tableau - 

{INCLUDE [Commodity],[Country]:AVG([% Weight])}

PowerBI Expression that i tried (it doesnt work) - 

Average per Commodity =

AVERAGEX(

    KEEPFILTERS(VALUES('Input'[Commodity])),

    CALCULATE(AVERAGE('Input'[% Weight]))

)

[v-deddai1-msft]

Hi @Diva20 ,

Did the reply above  resolve your issue? Please consider Accept it as the solution to help the other members find it more quickly. If not, would you please inform us more detailed information( your data and expected output (by OneDrive for Business)) if possible? Then we will help you more correctly.

Please do mask sensitive data before uploading.

Thanks for your understanding and support.

Best Regards,

Dedmon Dai

[amitchandak]

@Diva20 , Try a measure like

averageX(summarize(table, Table[Commodity], Table[Country], "_1", [% Weight]),[_1])

[Ashish_Mathur]

Hi,

Share some data, explain the business context and show the expected result.