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...
  • 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

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