Forum Discussion

Peter_2020's avatar
Peter_2020
Helper III
3 years ago
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...
Need Help
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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.

v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Peter_2020 ,

 

Please try:

Measure = 
var _a = SUMX(ALL('Table'[HOURS]),[HOURS])
var _b = SUM('Table'[HOURS])
return IF(ISINSCOPE('Table'[CODE]),_b,_a)

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.

  • Peter_2020's avatar
    Peter_2020
    Helper III
    3 years ago

    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. 

    • v-jianboli-msft's avatar
      v-jianboli-msft
      Community Support
      3 years ago

      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.

      • Peter_2020's avatar
        Peter_2020
        Helper III
        3 years ago

        Hi v-jianboli-msft , 

        excellent! That's exactly what I needed. Thank you a lot for your help!