Forum Discussion
Related Table in Matrix Visualization does Not SUM UP
Hello Forum,
I have a rather complicated question...
Hope you can understand want i want to achieve.
I have the following relations between tables:Relations between tables
Since the "Forecast" Table has multiple Forecast Dates with a different Forecasted Quantity for differents Order Dates, I wanted to match him up with the "Orders" Table where one Order Date has a unique Order Quantity.
This works okay my only poblem is i cannot get the order quantity in the resulting report shown below to sum up.
Could i get a workaround to get the Order Quantity to sum up?
I do know why power bi does no sum up the order quantity (because it is them sum of the order table and therefore correct) but i still need it to sum up.
Unfortunaley Merging Queries is not an option, since i want to consider a time period of forecasting dates and orderdates (sometimes order dates get postponed to another date and all the forecast quantities with the old order date would get lost --> therefore no exact matching between order tables and forecast table possbile!)
3 Replies
Hi,
Why are there 2 date slicers? Shouldn't there be just one date slicer for computing both order and forecast quantity?
sometimes forecasts have forcasting dates for specific order dates, problem is they eveuntally disappear because the forcasted order has been rescheduled to another order date. sounds confusing i know.
at the end of the day i am looking to be able to calc a total of a measure not based on a row but on a colmn, problem is that column only exists if i create a matrix in the report view, i cannot turn it into a calc column within one of my tables. i know that measure within the report work on rows not on columns but is there any workaround?
