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 ex...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous ,

     

    You may refer to the measure below.

    Measure =
SUMX (
    VALUES ( Table1[ORDER] ),
    CALCULATE ( DISTINCTCOUNT ( Table1[INVOICE] ) - 1 )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
7 years ago

Anonymous ,

 

You may refer to the measure below.

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

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