Forum Discussion

IsabelleP's avatar
IsabelleP
Frequent Visitor
7 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    7 years ago

    IsabelleP,

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





    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    IsabelleP,

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





    Regards,
    Lydia

  • saadat_rda's avatar
    saadat_rda
    Frequent Visitor
    3 years ago

    Hi Anonymous 

     

    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?