Convert a table into a card

Hi Anonymous,

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!

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

or through dax, to put in card visual

https://dax.guide/sum/ 

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

Hi Anonymous ,

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.