Forum Discussion
Power BI Matrix Woes: Understanding Total Discrepancies Across Time Periods
Good morning everyone, I apologize for disturbing everyone again, but I'm literally going crazy with the totals in Power BI matrices. I've created measures to, obviously, perform calculations based ...
I think the issue is in those measure:
SLA Bonus AGV L25 =
SUMX(
VALUES('Siti Attività'[Sito Area]),
IF(
[SLA AGV L25] <= 0.92,
BLANK(),
IF(
[SLA AGV L25] <= 0.95,
0.03 * [Costo Lotto L25 AGV],
IF(
[SLA AGV L25] <= 0.97,
0.04 * [Costo Lotto L25 AGV],
IF(
[SLA AGV L25] <= 1,
0.08 * [Costo Lotto L25 AGV],
BLANK()
)
)
)
))
and
SLA Penale AGV L25 =
SUMX(
VALUES('Siti Attività'[Sito Area]), -- Itera su ciascun sito
IF(
[SLA AGV L25] <= 0.92,
IF(
(0.92 - [SLA AGV L25]) * [Costo Lotto L25 AGV] < 0,
[Costo Lotto L25 AGV],
(0.92 - [SLA AGV L25]) * [Costo Lotto L25 AGV]
)
)
)