Forum Discussion
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...
afbraga66 , Dim_language has two path to f_downtime.
In such case we do not join dim to both the dim and use it value to filter the measure
or join to one and use filter in measure to filter that
How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8
or
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é.
Hey amitchandak
Afterall it was some data issues. I have managed to find what was causing it.
Thanks for help.
Best regards,
André