March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
23 | |
15 | |
12 | |
9 | |
8 |
User | Count |
---|---|
41 | |
32 | |
29 | |
12 | |
12 |