Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I have 3 tables that are linked with a date key or an item key.
The structure is like:
ItemMaster
Item (key) | Description | Value |
1 | Keys | 5 |
2 | Tube | 10 |
tblOrderState
Item (key) | Order | State | Date (key) |
1 | A2 | 50 | 01.01.2020 |
1 | A3 | 95 | 01.02.2020 |
the tblOrderState is linked with the calendar table.
On the page is a filter for the whole page for the current week.
Now I need to determine the number of orders that have the "50" regardless of the date.
How would you do that?
Can you show how you are slicing your data? you could try
Measure =
CALCULATE (
COUNTROWS ( tblOrderState ),
FILTER ( ALL ( tblOrderState[OrderState] ), tblOrderState[OrderState] = 50 )
)
Thanks for your reply!
It is not working since I am using a filter for the week on the whole page.
Filter on this page: week
How can I cut the active date relationship?
The following measure counts the orders regardless the date relationship:
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
84 | |
39 | |
25 | |
21 |