Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
2021 | 2021 Total | ||||||||||||
Row Labels | January | February | March | April | May | June | July | August | September | October | November | December | |
Company A | 45,064 | 45,664 | 66,988 | 79,499 | 93,733 | 62,808 | 65,191 | 84,753 | 55,461 | 61,761 | 42,569 | 56,936 | 3,000,000 |
Company A Plan A | 14,969 | 15,168 | 22,251 | 26,407 | 31,135 | 20,863 | 21,654 | 28,152 | 18,422 | 20,515 | 14,140 | 18,912 | 2,000,000 |
Company A Plan B | 30,095 | 30,496 | 44,737 | 53,092 | 62,598 | 41,945 | 43,537 | 56,601 | 37,039 | 41,246 | 28,429 | 38,024 | 1,000,000 |
Long story short, I am taking over a poorly written BI report. A matrix table is made based on the following Hierarchy: Company Name > Companies Plans. The values are coming from the measure [Totals] which is a long long long dax measure written because the model was set up poorly. The company Plan totals should sum up to the company total above, and it does. However, when summing it sums up to the year subtotal, it is not correct. I am wondering the quickest solution to this problem to get this report back online. I will be spending the next few weeks rebuilding the report, but stakeholders need it in the mean time.
Thanks.
Solved! Go to Solution.
@Anonymous , Try this
Sumx( addcolumns ( summarize( Table, Table[Company], Table[Month Year]), "_1", [Current Meaure]), [_1])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
@Anonymous , Try this
Sumx( addcolumns ( summarize( Table, Table[Company], Table[Month Year]), "_1", [Current Meaure]), [_1])
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
73 | |
63 | |
61 |