Forum Discussion

a__miller's avatar
a__miller
Frequent Visitor
4 years ago

Filter showing multiple values

Hi, the filter is showing multiple values when it is only supposed to show the value when the Week Offset equals 0. Is there something wrong with the measure?    
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
4 years ago

Hi,

Ensure that Fical Year, Week offset and Period have all been dragged from the Calendar Table.  There should be a relationship (Many to One and Single) between the Date column of the Data Table to the Date column of the Calendar Table.  You may simplify your measure to:

= CALCULATE([Cumulative Past Due Backlog - WHSL],'Calendar'[Week Offset]=0)

Hope this helps.