Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
44 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |