Table and Card Visual are not totalling correctly

[MishMishx]

Hello All,

I am very new to powerbi and DAX, so please excuse my basic question

I am finding this issue with my visuals, they are totalling higher or including some sort of data that is outside the current filtered conditions. 

When I download the CSV, the sum shows much lower numbers compared to the powerBI, but these numbers also match what we were expecting

The actual data fields are not calculated but already provided in our company traded data, so there are no current measures behind them and I assume just a SUM needed by the visual? 

Please let me know if I need to be doing something smarter here, or if this has been answered before. I am struggling to find a post that applies to my issue as I don't currently have any measures behind the visuals and quite a few filtered conditions. 

[amitchandak · Accepted solution]

@MishMishx , to have same value in card visual, just use formatting/display unit as none

I doubt I have seen a case where power bi summing up wrong.  Something is filtered in CSV, more or less

Can you share sample a sample pbix after removing sensitive data.