User Profile
IPGeorgiev
Helper III
Joined 6 years ago
User Widgets
Contributions
Re: RankX - questions - Rank based on measure from another table
Hi Greg_Deckler , I will try to simplify it, thanks for your time! Table 1 Employee Name Date Type Positive responses Negative responses agent1 7/22/2021 Billing 1 5 agent1 7/22/2021 Payment 2 0 agent1 7/22/2021 Charge 5 0 agent2 7/22/2021 Billing 4 1 agent2 7/22/2021 Payment 6 0 agent2 7/22/2021 Charge 2 1 agent3 7/22/2021 Billing 4 2 agent3 7/22/2021 Payment 1 0 agent3 7/22/2021 Charge 10 3 agent4 7/22/2021 Billing 4 1 agent4 7/22/2021 Payment 2 0 agent4 7/22/2021 Charge 6 0 agent5 7/22/2021 Billing 3 0 agent5 7/22/2021 Payment 5 3 agent5 7/22/2021 Charge 2 2 agent6 7/22/2021 Billing 8 1 agent6 7/22/2021 Payment 6 0 agent6 7/22/2021 Charge 7 0 agent7 7/22/2021 Billing 4 0 agent7 7/22/2021 Payment 6 1 agent7 7/22/2021 Charge 2 1 agent8 7/22/2021 Billing 4 1 agent8 7/22/2021 Payment 7 1 agent8 7/22/2021 Charge 8 2 agent9 7/22/2021 Billing 3 0 agent9 7/22/2021 Payment 5 1 agent9 7/22/2021 Charge 7 0 agent10 7/22/2021 Billing 9 0 agent10 7/22/2021 Payment 5 0 agent10 7/22/2021 Charge 4 1 Table 2 Employee Name SupervisorName agent1 Supervisor1 agent2 Supervisor2 agent3 Supervisor3 agent4 Supervisor1 agent5 Supervisor2 agent6 Supervisor3 agent7 Supervisor1 agent8 Supervisor2 agent9 Supervisor3 agent10 Supervisor1 There is a relationship between those two tables on EmployeeName level - Many to One There is a measure in Table 1 : Positive% = SUM(Table1[Positive responses]/(Table1[Postive responses]+Table1[Negative respnonses]) The final output should look like this: Row Labels Sum of Positive responses Sum of Negative responses Positive% Rank Supervisor1 50 9 0.847457627 2 Supervisor2 41 11 0.788461538 3 Supervisor3 51 7 0.879310345 1 Ranking here is with the following logic -the higher the Postive% the better - so the Supervisor whose team has the highest Postivie% should be first. Many thanks in advance! Best regards, Ivan774Views0likes0CommentsRankX - questions - Rank based on measure from another table
Hi All, I would like to ask for some help and will really appreciate it! Basically I have one table(Table 1) which has the following columns employee names Supervisor name I have another table (Table 2) which has raw data for each employee and the following columns: Employee name Date Type of contact Program sub groups Positive reponeses Negative responses I have table 3 which has Program sub groups Program goups ( basically few sub groups will have the same group and for exmaple 10 sub groups will form only 2 groups) Out of table 2 I have added a measure to show the % of positive reponses – Positive% = Positive responses/(positive reponses+negative responses) Then I create a pivot which will have as rows Supervisor name and as a value the Postive% Now I want to add a second column (under values) which will rank those supervisors based on the postive% - the highest should get RANK 1 etc. I will also want to filter the matrix to include only specific groups. Do you have any ideas how to achieve this? Many thanks in advance!893Views0likes3CommentsCount consecutive days on a specific status
Hi All, I want to count the number of consecutive days for each attendance status for a specific employee. So here an example of the data: Emp Id Emp Name Project Id Program Date Schedule Status 111111 Max Mustermann 55 Test Progrma 07/01/2021 Off 111111 Max Mustermann 55 Test Progrma 07/02/2021 Work 111111 Max Mustermann 55 Test Progrma 07/03/2021 Work 111111 Max Mustermann 55 Test Progrma 07/04/2021 Work 111111 Max Mustermann 55 Test Progrma 07/05/2021 Work 111111 Max Mustermann 55 Test Progrma 07/06/2021 Work 111111 Max Mustermann 55 Test Progrma 07/07/2021 Work 111111 Max Mustermann 55 Test Progrma 07/08/2021 Off 111111 Max Mustermann 55 Test Progrma 07/09/2021 Off 111111 Max Mustermann 55 Test Progrma 07/10/2021 Work 111111 Max Mustermann 55 Test Progrma 07/11/2021 Work 111111 Max Mustermann 55 Test Progrma 07/12/2021 Work 111111 Max Mustermann 55 Test Progrma 07/13/2021 Work 111111 Max Mustermann 55 Test Progrma 07/14/2021 Work 111111 Max Mustermann 55 Test Progrma 07/15/2021 Work 111111 Max Mustermann 55 Test Progrma 07/16/2021 Work 111111 Max Mustermann 55 Test Progrma 07/17/2021 Off 111111 Max Mustermann 55 Test Progrma 07/18/2021 Off 111111 Max Mustermann 55 Test Progrma 07/19/2021 Work 111111 Max Mustermann 55 Test Progrma 07/20/2021 Work 111111 Max Mustermann 55 Test Progrma 07/21/2021 Work 111111 Max Mustermann 55 Test Progrma 07/22/2021 Work 111111 Max Mustermann 55 Test Progrma 07/23/2021 Work 111111 Max Mustermann 55 Test Progrma 07/24/2021 Off 111111 Max Mustermann 55 Test Progrma 07/25/2021 Off 111111 Max Mustermann 55 Test Progrma 07/26/2021 Unscheduled 111111 Max Mustermann 55 Test Progrma 07/27/2021 Unscheduled 111111 Max Mustermann 55 Test Progrma 07/28/2021 Unscheduled 111111 Max Mustermann 55 Test Progrma 07/29/2021 Unscheduled 111111 Max Mustermann 55 Test Progrma 07/30/2021 Unscheduled 111111 Max Mustermann 55 Test Progrma 07/31/2021 Unscheduled So as on output I want to have a matrix where under ROWs I will put - > Emp Name/Schedule Status and under values - the max consecutive days for each status. So the output will be for this case: Name/ScheduleStatus Max Consecutive Max Mustermann "-Work" 7 "-OFF" 2 "-UNSCHEDULED" 6 I would really appreciate if someone can help me with this - at a first glance it looks rather easy, but turns out to be quite hard, at least for me. Thanks in advance!! BEst regards, IvanSolved1.3KViews0likes3CommentsRe: Measure to calculate impact in a matrix
Hi Jihwan_Kim , thanks a lot for the response! Strange, but it doesnt seem to work for me - when I add it it doest two things: Always shows 0.00 as value And for some reason shows all possible names in the list, although before that I have applied some filters via slicers which should reduce the number of names shown based on time frame , location etc. (additional columns in my raw data). Not sure why this is happening. Any ideas? Thanks a bunch in advance! Best regards, Ivan1.1KViews0likes0CommentsMeasure to calculate impact in a matrix
Hi All 🙂 I want to put a measure in a matrix which will calculate an impact. Here a sample file can be downloaded https://drive.google.com/file/d/1YzExY86qCzy4jYpRQwL-KZHqBSs4KbU2/view?usp=sharing So basically it will be matrix in Powe BI where Agent name will be as a row, Postive and Negative will be a SUM of all positive or all negative responses for each agent and total responses will also be a sum (a separate column in the raw data). Then the question is how to get the impact formular shown in the excel file replicated in the matrix in power bi? Many thanks in advance! Best regards, Ivan1.1KViews0likes3CommentsRe: Bucket via measure to column chart
Hi Ashish_Mathur , well its quite big I think - I mean its daily data and its being stored for 1 year so there a multiple files and the total number of rows is around 1mil. I can get a file a few days but with the all data it will be quite hard to have it. Should I upload a file for a week for example ? THanks! Best regards, Ivan4.5KViews0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.