Forum Discussion
Solved
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 ...
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
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.