Forum Discussion

tomerfaith's avatar
tomerfaith
Frequent Visitor
8 years ago

Interaction Between FILTER() and ALL()

First let me describe the situation: I have a table with "Order Date" , "Supply Date" and "Sum" columns, and a date table. I created a relationship between "Supply Date" and the date table. and i n...
Need Help
tomerfaith's avatar
tomerfaith
Frequent Visitor
8 years ago

Yes, the problem is that when I use the implemantation you suggested:

Order Sum Open At The Time 2 = VAR minDate = MIN('Calender'[Date]) RETURN
                            VAR maxDate = MAX('Calender'[Date]) RETURN 
                            CALCULATE(SUM('ORD'[Sum]),//ALL('ORD'[Supply Date]),
                                FILTER(ALL('ORD'),
                                     'ORD'[Order Date]<=maxDate && 'ORD'[Supply Date]>=minDate
                                      )
                                    )

I lose all the filters in my report.
when I actually only want to lose the filters specificly on "Supply Date" column.
my question is how can I do this?

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi tomerfaith,

 

Check this:

 

Order Sum Open At The Time 2 = VAR minDate = MIN('Calender'[Date]) RETURN
                            VAR maxDate = MAX('Calender'[Date]) RETURN 
                            CALCULATE(SUM('ORD'[Sum]),//ALL('ORD'[Supply Date]),
                                FILTER(ALL('ORD'[Supply Date],ORD[Order Date]),
                                     'ORD'[Order Date]<=maxDate && 'ORD'[Supply Date]>=minDate
                                      )
                                    )

 

Thanks,
Xi Jin.