Creating a card which shows the sum of column values

[lenafherold]

Hello,

I have a simple question regarding visual creation in Power BI. I would like to use a card to show the sum of dollar amounts in a column. When creating a card visual using the column, however, I do not have a sum option available. By default, the value of the first row of the column shows in the visual. 

I tried creating a measure to SUM the column, and adding the measure to the card instead, but this didn't work either. 

Any suggestions? 

[Anonymous · Accepted solution]

Hi  @lenafherold ,

When your field is a text type, the Card vision automatically displays the value of the first line by default, and no Sum appears.

You can select Whole number in Column tools and add the "$" symbol

The data after Sum will appear.

Or you can try to use dax to display:

1. Create calculated column.

Value = VALUE(RIGHT('Table'[amount],1))

2. Create measure.

Measure = "$"&""&SUM('Table'[Value])

3. Result.

Best Regards,

Liu Yang

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

[Greg_Deckler]

@lenafherold Sounds like you have the wrong data type for the column. Sounds like it is set to text and it should be set to Currency.