Forum Discussion
Jorrafer25
3 years agoFrequent Visitor
Filter a table based other filtered table
Hello community! I need help filtering a table based on the selected values from another table. My company receives every few days the forecast about how many items should produce. That demand would...
- 3 years ago
Hi Jorrafer25 ,
Add a new measure to the original one
Forecast = SUMX ( SUMMARIZE ( FILTER ( ALL ( 'CutOffDates' ), [CutOffDate] < MAX ( 'Calendar'[Date] ) && [Version] IN VALUES ( Selection1[Version] ) ), 'CutOffDates'[Version], 'CutOffDates'[PartNo], 'CutOffDates'[CutOffDate], "1", CALCULATE ( SUM ( 'Forecast'[Quantity] ), FILTER ( 'Forecast', 'Forecast'[PartNo] = EARLIER ( 'CutOffDates'[PartNo] ) && 'Forecast'[Version] IN VALUES ( Selection1[Version] ) && 'Forecast'[Date] > EARLIER ( 'CutOffDates'[CutOffDate] ) ) ) ), [1] )The result is as follows :
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jialluo-msft
Community Support
3 years agoHi Jorrafer25 ,
Add a new measure to the original one
Forecast =
SUMX (
SUMMARIZE (
FILTER (
ALL ( 'CutOffDates' ),
[CutOffDate] < MAX ( 'Calendar'[Date] )
&& [Version] IN VALUES ( Selection1[Version] )
),
'CutOffDates'[Version],
'CutOffDates'[PartNo],
'CutOffDates'[CutOffDate],
"1",
CALCULATE (
SUM ( 'Forecast'[Quantity] ),
FILTER (
'Forecast',
'Forecast'[PartNo] = EARLIER ( 'CutOffDates'[PartNo] )
&& 'Forecast'[Version]
IN VALUES ( Selection1[Version] )
&& 'Forecast'[Date] > EARLIER ( 'CutOffDates'[CutOffDate] )
)
)
),
[1]
)
The result is as follows :
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.