Forum Discussion
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...
IsabelleP,
Have you enabled the "Allow unrestricted measures in DirectQuery mode" option? I am able to use SUMX function in DirectQuery mode.
Regards,
Lydia
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?