Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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 , 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]))