cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
IsabelleP Frequent Visitor
Frequent Visitor

SUMX alternative for Direct Query

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

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: SUMX alternative for Direct Query

@IsabelleP,

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

1.PNG
2.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Moderator v-yuezhe-msft
Moderator

Re: SUMX alternative for Direct Query

@IsabelleP,

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

1.PNG
2.PNG


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.