Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a City Name slicer which I need to filter three different visuals. Only one visual (which has a Managed Relationship connection between the data in the slicer and the data in the visual is working. I can't make managed relationship for the other two visuals even though they are based of of tables with city names. Is there another method? The city name is not in the visuals.
Thanks
Here is the pattern of activating inactive relationships using DAX -
CALCULATE(SUM([SalesAmount]), USERELATIONSHIP(FactInternetSales[CustomerKey], DimCustomer[CustomerKey]))
From what I see your relationship is many to many,bidirectional. This is not best practice. I recommend reading more about modelling and star schema.
Disregard my last message, I was using the wrong table in the dax formula.
I tried the DAX that you suggested but I'm getting the following error. I include the manage relationship join.
you can have in the model only 1 active relationship, but multiple inactive ones. Those inactive relationships can be activated using DAX. If you can provide a sample with dummy date I can help you
Here is the inactive relationship that I would like to active with DAX.
If the dimension table used by the column in the slicer has a relationship with the table that contain columns in the other visuals, the filter will work. If it does not work now it means your model was not set correctly or the interaction was removed or you do not have any column to build a relationship upon
The problem is that I can't build a relationship between the tables for the city names. The model won't allow me to do that because there is already a relationship on another column needed for a different join. Is there a method to join outside of the managed relationsships? I've tried the Format/Edit Interactions but that does not produce the correct results.
User | Count |
---|---|
80 | |
76 | |
70 | |
69 | |
54 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |