cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MistaBrown Frequent Visitor
Frequent Visitor

Card Visual to return value matching page level filter selection

Hello everyone,

 

I have included my DAX below; it is doing the math correctly, except it is not capturing the page level filter, which is multiple selections of Employee names.  The goal is to show overall team average timesheet completion as an indicator of the accuracy of actual time data in other visualizations.  I tried the Selectedvalue as a filter, but it doesn't work with multiple results.  There are 7 employees on the team.

 

Can anyone help with a suggestion?  Just fyi, the relationship in this model is on other columns.

 

Team Timesheet % = AVERAGEX('List Data',CALCULATE(AVERAGE('List Data'[Timesheet %])))  (Just to clarify I did try to add "
FILTER('List Data','List Data'[Employee Name]=SELECTEDVALUE('Work Plan Summary'[Resource]) without success.
 
'List Data'[Timesheet %] is a clalculated column "
Timesheet % = DIVIDE(CALCULATE(DISTINCTCOUNT('Timesheet Data'[End Date]),FILTER('Timesheet Data','Timesheet Data'[Description]='List Data'[Employee Name] && 'Timesheet Data'[End Date]>43466)),WEEKNUM(TODAY())-1)"
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Card Visual to return value matching page level filter selection

@MistaBrown ,

 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/multiple-selection-in-a-slicer-to-calculate-value/m-p/27853...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Card Visual to return value matching page level filter selection

@MistaBrown ,

 

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/multiple-selection-in-a-slicer-to-calculate-value/m-p/27853...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.