Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculate with DISTINTCOUNT doesn't return expected value to calculate Backorders

Hello everybody, I'm just getting started in Power BI and I can't find the way to get an expected result. Hope you can help me.

Let explain the idea, I need to count each time an Extra INVOICE is executed by order. For example in order 1, count 1 backorder. I would like to get the total Grouped By CUSTOMER as shown in the right image. I know the COUNT in BACKORDER match with values, but is not counting that I really need.

 

The matrix should show 4 where indicated.

 

I would really appreciate any help, have a nice day.

  • Anonymous ,

     

    You may refer to the measure below.

    Measure =
    SUMX (
        VALUES ( Table1[ORDER] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 )
    )
    

2 Replies

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    Anonymous ,

     

    You may refer to the measure below.

    Measure =
    SUMX (
        VALUES ( Table1[ORDER] ),
        CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 )
    )
    
    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you for the timely answer, hope it can help others in the future.