Forum Discussion

ebrownretail's avatar
ebrownretail
Resolver I
2 years ago
Solved

calculation not working

Hi! I am trying to pull what my next week forecast is, but the measure is not pulling through any information. Any ideas? As you can see in the screen shot it is summing but not filling in the rows....
Need Help
  • ebrownretail's avatar
    ebrownretail
    2 years ago

    i couldnt get the file to open so that was why i was asking, but i just figured it out. Its because the porgram didnt like i had multiple many to many relationships to the dates table for the walmart week. I changed the one going to my past sales history to a single instead of both relationship and it works and keeps everything else working as well. 

MattAllington's avatar
MattAllington
Community Champion
2 years ago

I can't be sure without seeing you data model, but I can tell you that there is a problem with your FILTER statement

 

FILTER(Dates,Dates[Date] = TODAY())))))

 

the first parameter Dates inside your filter is already filtered by your visual. It looks like it is the entire Date table, but in fact it is a filtered copy of your date table. The first thing to try is this

 

FILTER(ALL(Dates),Dates[Date] = TODAY())))))

ebrownretail's avatar
ebrownretail
Resolver I
2 years ago

Thanks. I added that and it did not change the issue.

 

I have a dates table that has 6 digit weeks on them

I have a projections table with 6 digit weeks

 

I am trying to get the table to bring back what the next weeks projection is by DC based on the 6 digit week number. Does this help?