Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
4 months ago
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 ...
Need Help
  • d_m_LNK's avatar
    d_m_LNK
    4 months ago

    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

d_m_LNK's avatar
d_m_LNK
Super User
4 months ago

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.

stribor45's avatar
stribor45
Post Prodigy
4 months ago

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

  • d_m_LNK's avatar
    d_m_LNK
    Super User
    4 months ago

    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.