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.
Hi All,
I have a project where I need to create a rolling Sum.
I have three tables involved, VScrapRates, VdateDim, and totalscrap.
My current DAX calculation is as follows:
Solved! Go to Solution.
@Kerrymr2 , is one of the other your columns un summarized?
Also, make sure yearmonth is coming from VDateDim and it is marked as date table
VDateDim is marked as a date table.
If I remove every column except Corporate scrap percentage from VscrapRates in the table it still happens.
If I remove every visual filter, still happens.
If I change the slicer attached to VdateDim, the value remains constant.
It may be that CorporateScrapPercentage is not summarized. Suggestions on what to try?
Thanks, it steered me in the correct direction. It was an issue where there was no relationship between VscrapRates[plant] and TotalScrap[Plant].
Cleaned up relationships, modified and added some measures and everything is working.
Thanks for steering me in the right direction.
K.
@Kerrymr2 , is one of the other your columns un summarized?
Also, make sure yearmonth is coming from VDateDim and it is marked as date table
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 | |
36 | |
21 | |
19 | |
15 |
User | Count |
---|---|
125 | |
37 | |
29 | |
29 | |
24 |