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
flath's avatar
flath
Icon for Helper II rankHelper II
4 years ago

Hi, a__miller ,

 

I can figure out two possibilities:

1. The measure "Cumulative Past Due Backlog - WHSL" was written with REMOVEFILTERS() ou ALL().
In this case, instead of filtering the measure using a boolean expression, you could use it inside a FILTER as following:

CALCULATE( [Cumulative Past Due Backlog - WHSL], FILTER( 'Calendar'[Week Offset] IN {0})

 

2. The relationship between table 'Calendar' and the table from where the values of the measure "Cumulative Past Due Backlog - WHSL" come from is broken or need to be edited.

 

Regards