Forum Discussion
SUMX
Dear all, I have a question regarding SUMX in relation with memory issues. I made a small table in which is displayed amount A, an amount B and C=MAX(A-B,0) for key users of a system. These ...
A =
CALCULATE (
SUM ( 'Fact'[Hours] ),
'Fact'[Soort] <> "Niet toegewezen"
)
B = divide(
)
B = divide(
CALCULATE (
TOTALYTD ( SUM ( 'Fact'[Start right] ), Datumtabel[Datum] ),
'Fact'[soort] = "AV"
),
12
)
12
)
So I'd try with a subset of employees only and run the Performance Analyzer to see what exactly is taking so much resources/time. Could be the time intelligence calculation.
For small subset of employee, it looks like that function A takes quite some time relatively, but are there ways to make this measure more efficient you think?