Sum of Sales per Invoice value for each data row

[Dn_wemn]

Hi,

I'd like to create a measure that displays the total sales per Invoice for each correspondent data row. In this example the total of Invoice = A is 70 (10 + 25 + 15 + 20). For B it's 65. Without any filter each row of Invoice = A should display 70, then for B 65. 

The measure I have created displays the total sum of all which is 135. So this is not correct yet.

Only when I apply the filter Invoice, it shows the correct number for each row:

How can this be achieved without applying any filter?

Btw, how can I add the pbix sample file as attachment?

Thank you

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure

Measure = calculate(sum(salesdata[sales]),all(salesdata[group]))

Hope this helps.

[Dn_wemn]

Thanks, works 🙂