Forum Discussion
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?
Thank you for your replies!
Ashish_Mathur, Fical Year, Week offset and Period have been dragged from the Calendar Table, and there is a One to Many Relationship between the Calendar Date Column and the Date Column in the Backlog table.
flath , The Updated Past Due Backlog measure's goal is to filter Cumulative Past Due Backlog into the current Fiscal Period (Currently in Period 6). Below is a snapshot of the values that feed the Updated Past Due Backlog Measure. Here is the Cumulative Past Due Backlog Measure. The values are only duplicated within the current period, and are filtered out of other fiscal periods.
WHSL Cumulative Past Due Backlog =
CALCULATE(
[WHSL - Past Due Open Backlog],
FILTER(
ALLSELECTED('Calendar'[Date]),
ISONORAFTER('Calendar'[Date], MAX('Calendar'[Date]), DESC)
)
)
Unfortunately, adding FILTER in the measure creates an error
Hi,
Share the link from where i can download your PBI file.
