Forum Discussion
Solved
Temporary Virtual Table based on Slicer
Have Table1 that includes columns: EmplId, ReportedDate, TimeReported, ProjectId, Activity. Table2 that includes columns: EmplId, ProjectId, AssignmentStartDate, AssignmentEndDate. Table3 has columns...
Hi Skykingcljr
The attached pbix is maybe what you're looking for... or not.
Please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.
Hi Skykingcljr
Add the following measure to table1
IsInScopeEmployee =
VAR SelectedCustomer = SELECTEDVALUE(Table3[Customer])
VAR MinDate = MIN(Table1[ReportedDate])
VAR MaxDate = MAX(Table1[ReportedDate])
RETURN
CALCULATE(
COUNTROWS(Table2),
FILTER(
Table2,
Table2[AssignmentStartDate] <= MaxDate &&
Table2[AssignmentEndDate] >= MinDate &&
RELATED(Table3[Customer]) = SelectedCustomer &&
Table2[EmplId] = MAX(Table1[EmplId])
)
)
Now, add the following filter to the table1 visual
IsInScopeEmployee = 0
You will get the following result, showing all times including those not related to a customer
--------------------------------
I hope this helps, please give kudos and mark as solved if it does!
Connect with me on LinkedIn.
Subscribe to my YouTube channel for Fabric/Power Platform related content!