Grand Total for each Article without Duplicates

[joshua1990]

Hi all!

I have a table that contains the value for each sales order:

Date	Article	Order	Value
01.01.2023	A	100	5
01.01.2023	A	101	5
01.01.2023	B	102	6

Then I have a table visual that shows all the details out of this table.

Here I would like to add a measure that sums up the Value for each article once.

For instance: In the example above we have 2 orders for the same article. Here I would like to consider the value 5 just only 1 time.

In the end the table should display this:

Date	Article	Order	Value
01.01.2023	A	100	5
01.01.2023	A	101	5
01.01.2023	B	102	6
Grand Total			11

How would you do this?

[tamerj1 · Accepted solution]

Hi @joshua1990 

please try

ValueMeasure =
ValueMeasure =
SUMX (
SUMMARIZE (
'Table',
'Table'[Article],
'Table'[Date],
"@Value", SUMX ( TOPN ( 1, 'Table', 'Table'[Order] ), 'Table'[Value] )
),
[@Value]
)

[ppm1]

Try

SUMX(VALUES(Table[Article]), [YourMeasure] )

Pat