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.
I'm hoping that I can explain what I am needing and it makes sense. I have 2 tables: a Calendar table that is used as a DAX generated table used for a date slicer and then an Employee table.
Type | Effective Date | Manufacturer | Unique ID |
Vaccination | 05/19/2021 | Unspecified | Employee A |
Vaccination | 02/03/2021 | Moderna | Employee B |
Booster | 06/20/2022 | Unspecified | Employee B |
Vaccination | 05/03/2022 | Moderna | Employee C |
Vaccination | 02/03/2022 | Moderna | Employee D |
Booster | 02/01/2022 | Moderna | Employee D |
Vaccination | 02/01/2022 | Moderna | Employee E |
Booster | 02/15/2022 | Moderna | Employee E |
Within my report, I have a Date slicer that stores the selection of the end user within a measure shown below.
Using the sample table for Employees, I would expect the total number to be 3 (Employee A, Employee B, and Employee D).
I have built measures using all kinds of Filters, and the calculations are taking too much processing power and time to populate a result. If anybody knows of the most simplistic way of getting these calculations, that would be great. Please let me know if there is more context that I need to provide to help better illustrate what it is I am trying to do.
Solved! Go to Solution.
Hi @joshua_dillon
Try to do something like this:
1. Disconnect the time table from your fact table.
2. Use this measure to check if the employee has an effective date between choosen date and choosen date minus 14 days:
5. Use this measure to check the items listed in your 3rd point:
7. Then put the TOTAL CHECK ADJ measure in a visual level filter and set it to be equal or greater than 1.
For example, setting the date to 10.02.2022 I got these employees listed:
Here you can find the test pbix file: https://filetransfer.io/data-package/NLwtgy9D#link
Please check if the solutions is ok.
Hi @joshua_dillon
Try to do something like this:
1. Disconnect the time table from your fact table.
2. Use this measure to check if the employee has an effective date between choosen date and choosen date minus 14 days:
5. Use this measure to check the items listed in your 3rd point:
7. Then put the TOTAL CHECK ADJ measure in a visual level filter and set it to be equal or greater than 1.
For example, setting the date to 10.02.2022 I got these employees listed:
Here you can find the test pbix file: https://filetransfer.io/data-package/NLwtgy9D#link
Please check if the solutions is ok.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |