Measures to properly sum and present data

[AdamJustyn]

Dear Community Members,

My simplyfied data model is like on the picture below. I have the Dates table as well.

There is a relation (1 to many) between ProductCode from Product table and ProductCode in Sales table.

What I would like to achive is presented on the picture below as well. I would like to have Total columns set as Measures to dynamically react to Dates Slicer.

Regards

@AdamJustyn 

[amitchandak · Accepted solution]

@AdamJustyn , Try like

calculate(sum(Sales[Quality]), allexcept(product, product[Base code]))

or

calculate(sum(Sales[Quality]), filter(allselected(product), product[Base code] =max(product[Base code]))

[AdamJustyn]

Thank you, @amitchandak 

Unbelievable! That easy. 🙂