Total Card for Not Summarized columns

[yaman123]

Hi, 

Is it possible to show the total for a column which is not summarized? I have a column which should equal to 530,000 but when i add this column to a card it is showing as over 1 billion. 

TIA 

Yasir

[Jihwan_Kim]

Hi, @yaman123 

Please correct me if I wrongly understood your question.

Can you try to add a measure to the visualization, instead of adding the column itself?

If it is OK with you, please share your sample pbix file, then I can try to come up with a more accurate solution.

Thanks.

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster.

[yaman123]

HI @Jihwan_Kim 

Sortry for the late reply.

I have a table which has a column with many categories and a volume column which shows the overall volume for that member. so each row for a category will show the total volume for that member for that period e.g 

Member    Volume       Category       Period

A                1000             ABC1           202102

A                1000             ABC2           202102

A                1000             ABC3           202102

So the volume (1000)  is the total volume for that member for that period. 

My total should be 53,000,000 but it is showing as 1 billion. Is there a way to show the correct vlaue? 

Thanks