Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
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
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |