Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Could you suggest an aquivalent for TOTALYTD() function in DirectQuery mode?
This should work with Date Slicer selection.
Thanks,
Amit
Solved! Go to Solution.
You can try to click "File"->"Options and settings"->"Options"->"DirectQuery"->check "allow unstricted measures" to enable TOTALYTD.
Do mind the that using the unstricted measures would affect performance in DirectQuery mode.
CALCULATE ( SUM ( Table[Column] ), FILTER ( ALL ( Calendar ), 'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) && YEAR ( 'Calendar'[Date] ) = YEAR ( MAX ( 'Calendar'[Date] ) ) ) )
this also works only when I enable unrestricted option in power bi desktop. will it still work on power bi portal or azure portal?
Do we need to enable same thing in that case and from where I can do it?
You just publish and don't have to change anything in Power BI Service.
You can try to click "File"->"Options and settings"->"Options"->"DirectQuery"->check "allow unstricted measures" to enable TOTALYTD.
Do mind the that using the unstricted measures would affect performance in DirectQuery mode.
thanks I could use it after the option is enabled.
I need to publish this on Azure portal, will it still work. Do I need to also enable this option anywhere else?
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |