Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |