Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 months ago
Solved

Measure showing different value in Table vs Card visual

Hi Everyone, I’m facing an issue where thesame measure shows different results in a Table visual vs a Card visual, and I’m not able to understand. Here is my sample data:   Product Sales Am...
Need Help
  • Abhilash_P's avatar
    Abhilash_P
    8 months ago

    Hi  Anonymous ,
     

    Table visual applies row filters (row context), so Power BI filters automatically for each row:

    • Product = A → 120

    • Product = B → 350

    • Product = C → 180

    Since card visual has NO row context, It shows the total sum across the entire dataset.

    If you want the card to always ignore filters and return one consistent value, create new measure as below

     

    CALCULATE([Total Sales], REMOVEFILTERS())

    This removes all product-level filters and ensures consistent results across visuals.


    Thanks

Kedar_Pande's avatar
Kedar_Pande
Super User
8 months ago

Anonymous 

 

This is expected behavior - not a bug.

Table visual: Shows measure per row context (filtered by Product)

A: 120, B: 350, C: 180

Card visual: Shows measure in total context (no Product filter)

All products: 650

Your measure is working correctly.

 

If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande