Forum Discussion
Falongi_82
Helper I
Helper IHelp on Measure with ALLEXCEPT / ALLSELECTED - I'm LOST
Hi All, I'm facing to one problem with my following measure that works properly when I don't use my slicer carrier. Some capture to explain ------------- In this case, my column '%' work...
Hi Falongi_82 ,
Please try the measure.
M_PARCELS_% = VAR val1 = CALCULATE ( [M_PARCELS], VALUES ( Q_BPOST_SLA_DAILY[PICKING_DATE] ), ALLSELECTED ( Q_BPOST_SLA_DAILY ) ) VAR val2 = [M_PARCELS] RETURN DIVIDE ( val2, val1, 0 )If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-kkf-msft
Community Support
Community SupportHi Falongi_82 ,
Please try the measure.
M_PARCELS_% =
VAR val1 =
CALCULATE (
[M_PARCELS],
VALUES ( Q_BPOST_SLA_DAILY[PICKING_DATE] ),
ALLSELECTED ( Q_BPOST_SLA_DAILY )
)
VAR val2 = [M_PARCELS]
RETURN
DIVIDE ( val2, val1, 0 )
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Falongi_82Many Thanks Winniz