Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi everyone,
I have 2 main inputs which are Forecast and Sales_orderlist, connected using master_cus, master_mat and calendar table.
I have added a new column in Forecast table to classified if given the date, is the data considered as forecast or actual (past data).
Then use a measure to calculate the value. If it is Actual, it will calcualte the sum of quantity in Sales_orderlist table, elseif it is Forecast, it will calculate the sum from Forecast table.
The output of the measure is shown in the top matrix
All values are as expected except the grand total of 16,578,623 which I see that it is calculated from the grand total sum of the quantity in the Forecast table as the numbers are the same shown in the matrix below it.
My expectation for the grand total is to be 17,584,000 as a sum of the total column.
Share sample pbix file to help you.
User | Count |
---|---|
85 | |
81 | |
67 | |
63 | |
54 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |