Forum Discussion
Solved
Specific column
Hi all, I would like to ask you for your help. I have one table where I have following data: And what I need to do is use the filter for "OPERATION = "0090" AND "CODE"= "20" to get proper...
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 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!