Convert a table into a card

[alex_smith]

Basically I need to get the total of a table and present it as a card visual. 

The idea is that I have been given a power BI with multiple visual tables on it and I want to get ALL the Totals and then add them together. So, as I first step I would like to create a measure that gives me only the total one existing visual table. Any ideas? 

[v-yanjiang-msft]

Hi @alex_smith ,

If in the Total row of the table visual, the measure can get the correct result 9, then directly put it in a card visual.

If not, modify the formula like this:

Measure =
VAR _T =
    ADDCOLUMNS ( 'Table', "measure", "post your original formula here" )
RETURN
    SUMX ( _T, [measure] )

Best Regards,
Community Support Team _ kalyj

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

[Shaurya]

Hi @alex_smith,

From what I understand, you want something like this:

I was able to create this using a simple count measure:

Count of ProductName = COUNT('Product'[ProductName])

Let me know if this solves your problem or if there are any other scenarios involved in your use case.

Hope that helps!

[Anonymous]

Place the "code" column in the card. Check if there is available "count" option. Its the same as dax countrows

[alex_smith]

This is not working because, I need to filter the visual with FIlters that are measures. So, maybe the question should be how can I convert a measure to a calculated column? (in order to apply filters in the visual)

[Anonymous]

Simple sum should be enough, click on mark near "x"

or through dax, to put in card visual

https://dax.guide/sum/ 

[alex_smith]

There is not such an option, unfortunatelly. Other info that might help, the table visual has filters that depend on other measures.