how to calculate summation of QTY column based on unique value of Project ID Column.

[Anonymous]

Hi All,

I have one doubt. from the below table I need to get Total Qty=55 instead of 152. Can please help me here. Based on distinct Project ID I need the total Qty. 

Thank you for your time.

Regards 

Vivek B

[Anonymous]

Hi Johnt,

Appericiate for you time, the solution is  working

Thank You
Vivek

[johnt75 · Accepted solution]

You can use

Quantity =
VAR SummaryTable =
    SUMMARIZE ( 'Table', 'Table'[Project ID], 'Table'[Qty] )
VAR Result =
    SUMX ( SummaryTable, 'Table'[Qty] )
RETURN
    Result