SUMX alternative for Direct Query

[IsabelleP]

Dear Community,

I want to do the following: take the revenue of all online channels and devide it through the total revenue. I've created this formular but unfortunately, SUMX is not supported in Direct Query Mode.

Online Share of rev. = SUMX(FILTER(vPriceComparison;vPriceComparison[salesChannelType]="ONLINE");SUM(vPriceComparison[financialTurnoverNetEuro])/SUM(vPriceComparison[financialTurnoverNetEuro]))

Is there an alternative?

Many thanks

Isabelle

[saadat_rda]

Hi @v-yuezhe-msft 

The option to allow unrestricted measure in powerBI direct query setting does not appear in my powerBI. Has this been removed since or has the location changed?

[v-yuezhe-msft · Accepted solution]

@IsabelleP,

Have you enabled the "Allow unrestricted measures in DirectQuery mode" option? I am able to use SUMX function in DirectQuery mode.





Regards,
Lydia