Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
71 | |
42 | |
21 | |
20 | |
13 |
User | Count |
---|---|
125 | |
41 | |
34 | |
26 | |
24 |