Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 (Dim_Language) which will filter other dimensions(Dim_DowntimeReason,Dim_DowntimeType), which in turn filter the fact table (F_DOWNTIME). Since I have the language the relationship between the dimensions and fact tables becomes a many-to-many relationship. To solve this I created bridge tables. So far so good. My issue now is that I want to filter the fact table with the dimensions, but if I enable the BOTH direction on the relationship betwen F_DOWNTIME/Dim_DowntimeReason 1->* Dim_DowntimeReason, I get the error below.
How would you approach this situation?
Thank you.
Best regards,
André
Solved! Go to Solution.
@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
https://docs.microsoft.com/en-us/dax/treatas-function
@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.
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é
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
72 | |
63 | |
52 | |
49 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
57 |