Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Say I have the following data model:
The idea is to build three slicers at report level - Organization, Customer and Department.
When filtering data by Organization, the Customer and Department slicers should show the results regarding the Organization values that are selected on its slicer. That should then filter the fact tables results by intersecting the results of the Customer and Department values.
It seems that Power BI does not allow for the activation of the relationship between DIM_ORGANIZATION and DIM_DEPARTMENT because that would introduce ambiguity:
Is there any way to achieve what I need by redesigning my model? Or is the model valid and I should focus on reaching a solution based on DAX or report level functionalities?
Solved! Go to Solution.
@Anonymous , If you are looking to filter those in slicer. Create a measure in fact
countrows( Fact_sales) + countrows( Fact_order)
And use that in the visual level filter of these slicers and check for non-blank values
you can use that in other visuals too, as per need
refer
https://www.youtube.com/watch?v=cyOquvfhzNM
@amitchandak
When you write "join directly" do you mean something like this?
Having this design would not filter Customer and Department values when using the Organization slicer.
@Anonymous , If you are looking to filter those in slicer. Create a measure in fact
countrows( Fact_sales) + countrows( Fact_order)
And use that in the visual level filter of these slicers and check for non-blank values
you can use that in other visuals too, as per need
refer
https://www.youtube.com/watch?v=cyOquvfhzNM
@Anonymous , You are having two path to reach a Fact like sales from Organization. Power bi need only one path.
So either merge ognizations with both tables. Or, if there is a column in fact where it join directly then do not join with dimension. Join with fact
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
146 | |
110 | |
107 | |
86 | |
63 |