Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi! my current data model is presented above. However, I need to introduce a date column to the dimension tables and make a relationship with calendar table as well. If I do so, I will end up with many-to-many relationship of dimension tables with calendar and dimension tables with fact table. What is the best way to work with such cases?
Here you can find a sample data and board to play with.
@chulpanvl , Do not create a relationship if you just want to filter the slicer of other dimensions using dates
You can create a measure like this using a dim table and date in it and use it in the visual level filter and check for not blank
new measure =
var _max = maxx(allselected(Date),Date[Date])
var _min = minx(allselected(Date),Date[Date])
return
Countrows( filter('dim1', 'dim1'[Date] >=_min && 'dim1'[Date] <=_max))
How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8
@amitchandak thank you for your response!
In the end I want to create a measure based on my fact table which is filtered by dimension table (see a screen) which will also take into account differences in groups of items from year to year.
I explained my case in more detail in this topic.
User | Count |
---|---|
93 | |
83 | |
77 | |
73 | |
66 |
User | Count |
---|---|
115 | |
104 | |
93 | |
64 | |
61 |