undefined

[Anonymous]

Hi i have table with column rank, i need to filter Rank1 and Ran2 and i need to sum the rank1 + rank 2 how can i do it.
Here is sample data screen shot for your reference

[Anonymous · Accepted solution]

Hi @Anonymous ,

Pleasetry below steps:

1. below is my test table

Table:

2. create a measure with below dax formula

Measure =
VAR str =
    CONCATENATEX ( 'Table', [Rank], "," )
VAR tmp =
    FILTER ( ALL ( 'Table' ), CONTAINSSTRING ( str, 'Table'[Rank] ) )
VAR _val =
    SUMX ( tmp, [Value] )
RETURN
    IF ( ISFILTERED ( 'Table'[Rank] ), _val )

3. add a table visual with fileds, add a slicer with field, add a card visual with measure

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523