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.
I have been asked to include the budget (screenshot) for various categories in the dashboard (see below) I have created. The problem I have is that they can't provide it by week which is how the dashboard is setup so they want me to apply the same totals for each week. The problem I am having is that the total line is not adding up the total for each line. It's applying the same value as the other lines. Is there anyway to get the total line to sum each line to get a grand total for that column? Thanks for your help.
For some reason I can't get this formula to work. When I try it as a measure and column I am not able to enter the table and column name after "SUMX". I can only reference the table itself. When I try this formula (
use the following measure pattern for budget :
sumx( tbl_name[col_name] , calculate( sum( tbl_name[budge_col_name])))
--> sumx(tbl_name[week_start_date] , calculate( sum( budget_table_name [budge_col_name])))
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |