Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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?
@IsabelleP,
Have you enabled the "Allow unrestricted measures in DirectQuery mode" option? I am able to use SUMX function in DirectQuery mode.
Regards,
Lydia
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |