Forum Discussion
Subtotal miscaculation using an IF function
Hello, I have been strugglin to solve the situation with the formula below: DM EX 50% = IF([GAP HORAS]<0,0, ((SUM('PLANNED HOURS'[MAINTENANCE BUDGET]) - SUM('WORK_ORDER_CODING_UIV'[MAINTENA...
Hello,
Below is the link to download the PBI Sample, as requested (couldn't find a way to attach it here):
https://mega.nz/file/EZoFma5L#IzVrFTbbQjb0mKfktiu3Nc4GYOEIJ1Z6Avvja9sQkRM
I have a column called "GAP HORAS" and I created a measure that uses this column with the following expression:
Measure = IF(SUM(data[GAP HORAS])<0,0,1)
What happens is that per row level, the formula is okay, but at subtotal level it is not. For example the correct answer for half of the matrix would be 8 instead of 0 (the sum of each individual row instead of recalculate the value at subtotal/total level.)
Thanks in advance.