Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
User | Count |
---|---|
57 | |
21 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |