Forum Discussion

afbraga66's avatar
afbraga66
Helper III
3 years ago
Solved

Ambiguous paths in data model

Hello,   Currently on my data model, I am facing a situation in which I'm not seeing a decent way to handle it. I want to leverage language filtering in the model. For this I created a dimension (D...
Need Help
afbraga66's avatar
afbraga66
Helper III
3 years ago

Hey amitchandak 

 

So I tried to add TREATAS() to my measure, but it is not working correctly when I filter the Language Code.

 
Downtime (min) =
CALCULATE(
    SUM(F_DOWNTIME[Duration Minutes 2]),
    USERELATIONSHIP(Dim_AREA[%Key1_(EMPRESA.COD_AREA)],F_DOWNTIME[%FKey1_(EMPRESA.COD_AREA)]),
    USERELATIONSHIP(Dim_Calendar[Manufacturing Date],F_DOWNTIME[Manufacturing Date]),
    USERELATIONSHIP(Dim_PLANT[Plant Code], F_DOWNTIME[Plant Code]),
    KEEPFILTERS(NOT F_DOWNTIME[Downtime Type Code] IN {"1","2","4","5","Z","Y"}),
    TREATAS(VALUES(Dim_Language[Language Code]),Dim_DowntimeType[Language]),
    TREATAS(VALUES(Dim_Language[Language Code]),Dim_DowntimeReason[Language])
)
 
It returns:

If I remove the last TREATAS() it works:

Can you help me understand?

Thank you,

André.


 

  • afbraga66's avatar
    afbraga66
    Helper III
    3 years ago

    Hey amitchandak 

     

    Afterall it was some data issues. I have managed to find what was causing it.

    Thanks for help.

     

    Best regards,

    André