Forum Discussion
Creating a Slicer from a Many to One Relationship
Hello, I am trying to create a matrix visual showing "Open Orders" and "Forecast Value" by "MonthYear". I would like to filter the matrix using "Forecast Version" which is a text field attributed to...
Hello,
If I understand correctly you would like to push the filter Forecast Version up to Date table in order to reach Orders. Your model does not allow this, you should use DAX measures instead. It can be done, but it would be very useful if you could share a sample data for the table Forecast Data and Orders.
I would give a try to something like this:
Open-Orders =
CALCULATE(
SUM(Orders[Open Orders]),
TREATAS(
VALUES('Forecast Data'[Date]),
Orders[Order Date])
)