Default Values For Filtering Page

[JMccoy92]

Hello All, I have a problem I know the community can help me fix. This report I am workin on is for voting that is happening within the company by upper managment. I am familiar with star schemas and have my data set up in this way. Votes and nominations as fact tables, tied in with dimensions for filtering.  In my report I have a page that is being used to describe Employee Details. I have a Main Page with a button that navigates the user to this page. On this page, there is a card on the right hand that holds the employees name. Below, left side houses a tabular visual with all employees that have been voted on, along with thier vote count,  weighted vote, and average. When a user clicks on the tabular visual employees name, data cards populate based on the employee selected.  My question is in regards to the default user that is in the right hand corner. When a employee is selected, the name changes as expected. However, I have received feedback that the employee that shows up as default isn't even being considered and will not be receiving any votes. I try to drag flags that represent this and the filter section will not allow me. It would be nice if all of the visuals would defualt to a certain user. One that should be tracked on this page. Before anyone asks, I do need to keep employees that are not nominated. 

Help me!! and thanks for the effort I know this group will produce. 

[v-kelly-msft · Accepted solution]

Hi  @JMccoy92 ,

Create a measure similarly as below:

measure = IF(ISFILTERED('Table'[value]),CALCULATE(MAX('Table'[name]),FILTER(ALL('Table'),'Table'[value]=SELECTEDVALUE('Table'[value]))),"b")

And you will see:

If it doesnt help,would you pls attach some picture to show you expected output?

For the sample .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!