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.
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:
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 |
---|---|
54 | |
24 | |
23 | |
15 | |
11 |
User | Count |
---|---|
76 | |
59 | |
46 | |
17 | |
12 |