Different values between card visual and table visual

[swebb]

I'm having an issue where I am using the same conditional column, which does some math based on values in other columns, and gives an output dollar amount. I have two visauls on one page of my report. One is a card visual and the other is table. Filtering based on the same column, I get two different amounts. I'm not sure what to do here. Unfortunately this is happening across multiple values from the same table and some other card visuals I have on the same page. Similar scenario, all conditional columns that add some values and out put a dollar amount.

[v-stephen-msft · Accepted solution]

Hi @swebb ,

For the table visual, because of the existence of other fields, it will be affected by the row context, and the data will be different.

For a card visual, it can only have one field, and if it's a column, it will let you choose an aggregation action, such as sum below.

If there's only the Value column in the table visual, and then you also select the aggregate operation for sum, then the result of the table visual is the same as the card visual at this time.

Table visual in Power BI - Power BI | Microsoft Learn

Card visualizations (large number tiles) - Power BI | Microsoft Learn

If you still have doubts, it's better to provide some dummy data, along with the expected outcome.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.