Forum Discussion
Measure Matrix incorrect total
Hi Furio_P ,
This solution is correct, more details can be found at this link:
Power BI Measure Total Is Incorrect: How To Fix It | Master Data Skills + AI (enterprisedna.co)If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you all; in the meantime, I have identified the solution by reading, indeed, various other posts with similar cases. Essentially, I have modified the formulas affected by this issue by adding a 'sumx' at the beginning of the formula for the type of values (categories) in the initial column of the matrix. This way, the totals are correct. For example, the column.
For example, the column "SLA Malus" has seen its formula for measurement modified as follows:
SLA Penale AGV L25 = SUMX( VALUES('Siti Attività '[Sito Area]), 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] )) ) |
The bold orange section is the added formula segment in the measurement to obtain a correct result.
Thank you very much for all your guidance; if you have any specific suggestions for this type of solution or not, please let me know. I wouldn't want to have found a solution that isn't actually one.
Hi Furio_P ,
This solution is correct, more details can be found at this link:
Power BI Measure Total Is Incorrect: How To Fix It | Master Data Skills + AI (enterprisedna.co)
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.