Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Missing Values in SUMX Function

Hi,   For context, I have sales data and forecast data for each department in a company. The sales data is a feed from SQL and the forecast data is a table in PowerBI as shown below (where each dep...
Need Help
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Try changing the relationships with the Dates table to be one-to-many, with Dates on the one side, and make sure that they are single directional. You want the filters to flow from the Dates table to the others, you do not want the filters flowing in both directions.