Total sum based on condition in other column

[Anonymous]

Hi all,

I'm struggling with creating a measure with the sum of revenue of products on a receipt. Please see below:

For total revenue per receipt I wrote the following formula to create a calculated measure:

Total revenue per receipt= SUMX(DISTINCT(sales[receipt code]),CALCULATE(AVERAGE(sales[revenue])))

As you can see my current results are wrong though. Any suggestions how I can solve this?

[Anonymous · Accepted solution]

Hi @Anonymous , Please try:

CALCULATE(SUM(sales[revenue]),ALLEXCEPT(sales[receipt code]))

[Anonymous]

Thanks @Anonymous! That fixes it!

Only one small edit: ALLEXCEPT requires 2 values: first the table name then the column name. So ALLEXCEPT(sales,sales[receipt code]).

[Anonymous]

Yes, sorry. Forgot about that.