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

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

stribor45's avatar
stribor45
Post Prodigy
4 months ago

This 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] )
)