Need to create a card chart which shows sum of multiple values in a column

[JothiKrishnan]

Hi Team, 

I need a create a Text Card, which needs to show the selected values in a single column, please help me on this

[v-kongfanf-msft]

Hi @JothiKrishnan ,

Did @_AAndrade  reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.

Best Regards,
Adamk Kong

[jgeddes]

You can create a comma delimited list with...

SelectedColumns = 
CONCATENATEX(
    VALUES('Table'[item]),
    [item],
    ", "
)

where 'item' is the name of the column with your values in it.

[JothiKrishnan]

@jgedde - Thank you for your assistance. The data I intend to use are in the same column, not a separate one. The column I require contains 1000 rows with distinct fields; I only need certain fields to be displayed as a KPI in the card view.

[jgeddes]

Ok. If you can share some data, or some dummy data that shows the baseline as well as your desired result it will be easier to provide a valid solution.

[_AAndrade]

Please Share same data and the desired output to clear understand your request.

[JothiKrishnan]

I've attached two images: the first one displays the total number of sub category list, and the second one displays the list of sub cateogiry. However, my scenario is for the text chart to display only the number of selected sub category, so in order to visualize it, I need to extract only the relevant sub category list from the selected column with out using slicer.

[JothiKrishnan]

I've attached two images: the first one displays the total number of sub category list, and the second one displays the list of sub cateogiry. However, my scenario is for the text chart to display only the number of selected sub category, so in order to visualize it, I need to extract only the relevant sub category list from the selected column with out using slicer.

[_AAndrade]

Like this:

In my example I only have 6 subcategories.

[JothiKrishnan]

Yes, how u did that, please help me on this

[_AAndrade · Accepted solution]

Is using a measure like @jgeddes show you before.
The measure is this:

NameSubCateg = CONCATENATEX(T_SubCateg,T_SubCateg[SubCategory], " | ")

T_SubCateg is my table and SubCategory is my column.