Forum Discussion
Specific column
Hi Peter_2020 ,
Sorry, I misunderstood before. If you are expecting it to show the sum of the hours for a specific PO, please try:
Measure = CALCULATE(SUM('Table'[HOURS]),ALLEXCEPT('Table','Table'[PO]))Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-jianboli-msft ,
thanks for your reply. It works perfect when you have table with 1 PO. But in my case I have in the table around 1000 PO´s and then it return the sum for all hours in total:
So the SUM of the hours must be defined for specific PO and must be in the same row, not in total.
P.
Hi Peter_2020 ,
Sorry, I misunderstood before. If you are expecting it to show the sum of the hours for a specific PO, please try:
Measure = CALCULATE(SUM('Table'[HOURS]),ALLEXCEPT('Table','Table'[PO]))Final output:
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-jianboli-msft ,
excellent! That's exactly what I needed. Thank you a lot for your help!
Hi v-jianboli-msft ,
one more request:
is it possible to adjust the formula to get proper sum of the hours with operation filter?:
it means that when I set filter for operation 0050 I get just the sum of the hours for specific operation - in this case 3,6 hours, for operation 0070 - 2,58; 0080 - 6,9 and so on....
so not the sum of all hours but just for specific operation...
Thank you in advance.
P.