Card not totalling correctly

[simonroyjones]

Hi 

I have a report which looks at profitablilty by month and the profit is stored in a field called value.

Value is a whole number.

When I create a bar chart everything looks OK and when I filter the card is fine but when I dont filer the card displays a completely incorrect figure.

I've displayed both states below.

Thanks

Simon

[vivran22]

Hello @simonroyjones ,

What are you using in the card visual? Is it a measure or a column?

When no filter has been applied on the card, it displays the result for the entire table. 

What is the expected value on the card when no filters are applied?

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter