Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
25 | |
12 | |
8 | |
7 | |
7 |
User | Count |
---|---|
25 | |
12 | |
11 | |
10 | |
6 |