DAX to populate distinct text with reference to column in matrix row

[DineshAgarwal]

hello Power BI Team,

Please assist with dax to get below result, thanks in advance

[DineshAgarwal]

@bhanu_gautam  We have unrelated table which has specific grading for combination as per below

we need to capture the grading based on concatenate for each row but capturing only for one combination 

Reason is Scorecard Concatenate is populating based on slicer if selected then that value will appear else all 

Below is example for Ind, similar formula is built for GEO, Customer, Branch, CRTY, Division

INDFiltersSelectedInvoicing =

IF (

    ISFILTERED ( 'DWH DIM_CUSTOMER'[CUST_MKT] ),

    CONCATENATEX ( FILTERS ('DWH DIM_CUSTOMER'[CUST_MKT]), 'DWH DIM_CUSTOMER'[CUST_MKT], "; " ),

    "ALL"

)

Scorecard_Concanteate =

var Division = [DivisionFiltersSelectedInvoicing]

var GEO = [RBUFiltersSelectedInvoicing]

var Customer= [CustomerFiltersSelectedInvoicing]

var Ind = [INDFiltersSelectedInvoicing]

 var Branch = [BranchFiltersSelectedInvoicing]

 var CTRY = [CountryFiltersSelectedInvoicing]

 RETURN Division & GEO & CTRY & Customer & Ind & Branch

 Now we want dax query in such a way that Customer is getting selected from Row of Matrix/table instead of slicer and below is dax for Grading which will appear in Matrix, along with other KPIs which coming from Facttable having Many to One relationship with DIM Table

Grading =

CALCULATE(

    SELECTEDVALUE('DWH FACT_O2C_Scorecard_LIVEDATA'[Cash_Health_Score],BLANK()),

    FILTER('DWH FACT_O2C_Scorecard_LIVEDATA','DWH FACT_O2C_Scorecard_LIVEDATA'[Concatenate_1]=[Scorecard_Concanteate])

)

[bhanu_gautam]

@DineshAgarwal , Your Customer table has duplicate values and multiple result, can you specify condition for which what value is required