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.
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.
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |