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

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
8 months ago

what does 180 stands for? I think 650 is correct. What's the expected output?

 

if you want to show a product, you can try below

 

Total Sales Product A = CALCULATE(SUM(Sales[SalesAmount]), Sales[Product] = "A")