Forum Discussion
Card visual with Filter rankx specific
Anonymous Are you wanting each employee to have ranked goals 1-N by location for the date selected (ie today)??
Is your Tech table a unique table for employee key?
If you can draw out your desired result with some sample data for about 3 employees over 5 days then I'll understand 100% what you need, but right now I'm still wrapping my head around the requirement.
You may need to use the KEEPFILTERS() function inside your RANKX, but if your Tech table is an employee table and location and Dates are in separate tables then you may not need that step....
Community ChampionAnonymous Are you wanting each employee to have ranked goals 1-N by location for the date selected (ie today)??
Is your Tech table a unique table for employee key?
If you can draw out your desired result with some sample data for about 3 employees over 5 days then I'll understand 100% what you need, but right now I'm still wrapping my head around the requirement.
You may need to use the KEEPFILTERS() function inside your RANKX, but if your Tech table is an employee table and location and Dates are in separate tables then you may not need that step....
AllisonKennedyThanks for your time!
Well, what I ultimately need is to use cards for different information that are referenced to a certain employee, but also have that be dynamic so if the employee moves location or Role that all the information will be correct for that specific employee. Thats why I wanted to have a rank calculation, but I am having trouble filter by that ranking.
I thought it would be best to rank based off the budget number and then give them a ranking for all the data and sort categories to reference.
Its tough because they are all in different tables. The Actuals, Budget, Dates, Techs, Location, Role, Clock Times.
Here is the data I am trying to use and card setup I'd like. I'd like it to be able to sort by Today or by Month. Data Example
Here are the main Calculations used to get this data.
Forecasting CalcHasone Value for Card
Rank Order Calc
Then, When I sort by a Single day the Today's Goal Doesnt pull in the specific correct goal for each employee with the Rank Function calculation. It just gives the total.
Single Day Data
AllisonKennedy I found a solution over the weekend. Looks like I just needed to add the measure into Calculate with the filter rank like you originally said. Thanks again!
1st =Calculate([today's goal],filter(Tech,[RankX by Actual] =1))