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.
Hi All I made a repport that has row and column subtotals and the row (althoug PBI says is column) totals are not adding up. Here is the measure that I did for the calculation of totals:
Hi @smedina_25 ,
I tested with simple dataset, both column total and row total add up values correctly.
For the unexpected result, it might be related to your source dataset. Please provide sample data of 'Query1', other linked tables if existing and the formula of [m_Single]. How to Get Your Question Answered Quickly
Best regards,
Yuliana Gu
Thanks! I'll try to get the data, in the meantime, I forgot to mention that the table on the screenshot was filtered data, without the filters the totals are ok.
Hi @smedina_25 ,
Please show sample data in source table 'Query1' and how you filter the matrix.
Regards,
Yuliana Gu
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |