Forum Discussion
Export data from visual
I have matrix visual in my report.
Matrix have 3 rows (Country, State , city) anmd I have filtered it out to one city for troubleshooting purposes. I also added a another row so the appid so in my visual i can see list of ids for this city. the count says 555 but when i export it i only see 350 records. I figured maybe issue is with exporting data from visual however i also when to perfomance analyzer and refrsshed the visual, copy the DAX code and run it inside Dax Studio and I am seeing there only 350 records. What is the issue?
The issue is your DAX total and how it's evaluating within the matrix. The total doesn't work like an excel total but evaluates in the context of the total row. If you can post a screenshot of the visual and the total measure we can help further with the DAX.
Here is a helpful video from Pragmaic Works as well explaining: Why Your Power BI Totals Are WRONG
5 Replies
The issue is your DAX total and how it's evaluating within the matrix. The total doesn't work like an excel total but evaluates in the context of the total row. If you can post a screenshot of the visual and the total measure we can help further with the DAX.
Here is a helpful video from Pragmaic Works as well explaining: Why Your Power BI Totals Are WRONGThis is the measure used for that column
CALCULATE ( [Approvals_2025], REMOVEFILTERS (Table_A), TREATAS ( VALUES ( Table_A[Country]), Table_B[Country]), TREATAS ( VALUES ( Table_A[State]), Table_B[State] ), TREATAS ( VALUES ( Table_A[City] ), Table_B[City] ) )
I believe it is the REMOVEFILTERS fuction that is complicating the totals here. Because your total row will be a total of the measure evaluated against only your TREATAS functions and not anything else in the filter context of the report. This is most likely why the total row doesn't match the results of the matrix or the export.
But the totals in matrix are correct? I am trying to export the list of these 555 records so I can compare with external data
Perhaps I misunderstood, apologies for that. If the results you are getting in the matrix (350 rows) and the total of the matrix (555 rows) aren't matching there is most likely a disagreement with the visuals filter context and the DAX total.
