Calculate the sum of the orders based on one row instead of the replicated value for all rows

[AmiraBedh]

I have the following Excel file which is imported to Power BI and it tracks the status for each order made by a client: 

Client   Order Status Quantity

1          345     1         20

1          345     2         20

1          345     3         20

2          567     1         12

2          567     2         12

2          567     3         12

I want to calculate the quantity like below :

Client   Order Status Quantity

1          345     1         20

1          345     2         20

1          345     3         20

1          567     1         12

1          567     2         12

1          567     3         12

Total                          32

It is like summing the distinct quantity for each Order which is 20+12=32 for each Client

[amirabedhiafi · Accepted solution]

YourMeasure=

     var CountAll = SUM('yourTable'[Quantity])

     var CountUnique =CALCULATE(SUM('yourTable'[Quantity]), 'yourTable'[Status]=1)

  return IF(HASONEVALUE('yourTable'[Quantity]), CountAll,CountUnique)

[AmiraBedh]

Worked like charm ! 

[SpartaBI]

@AmiraBedh try this:
Measure = SUMX(VALUES('Table'[Order]), CALCULATE(MAX('Table'[Quantity])))

[AmiraBedh]

It doesn't give me the expected ouput