Problem Filter

[nesrinehal20]

I have a "fac_assabil_ork" table and a rooting table. I want to filter a KPI calculated from the rooting by family and item, but the problem is that the rooting table doesn't contain the family and item.
I linked the sales(fac_assabil_ork) and rooting tables by the representative dimension, and the sales table linked by the item dimension, but I couldn't filter the KPI by family.
kpi : 

Nb Clients Non Plannifé =

CALCULATE (

    DISTINCTCOUNT ( ASS_ROOTING_TEST[PARTNER_CODE] ),

    ASS_ROOTING_TEST[IN_PLANNING] = "NON",

    TREATAS ( VALUES ( FAC_ASSABIL_ORK[ROLE_CODE] ), ASS_ROOTING_TEST[REP] )

)

[rohit1991 · Accepted solution]

Hi @nesrinehal20 

Could you please follow below steps: 

1. Dummy Tables created to solve problem. You can replace table names with your tables.
Table name : ASS_ROOTING_TEST

Table name : DimArticle

Table name : FAC_ASSABIL_ORK

2. Modelling :

3. Create Measure

Nb Clients Non Planifie = 
CALCULATE (
    DISTINCTCOUNT ( ASS_ROOTING_TEST[PARTNER_CODE] ),
    ASS_ROOTING_TEST[IN_PLANNING] = "NON",
    TREATAS ( VALUES ( FAC_ASSABIL_ORK[ROLE_CODE] ), ASS_ROOTING_TEST[REP] ),
    TREATAS ( VALUES ( FAC_ASSABIL_ORK[ITEM_CODE] ), DimArticle[ITEM_CODE] )
)

Outcome :