Forum Discussion
Flexible Scoring
I did some data modeling. Please download the file from same location and try.
Super UserPlease find the solution at : https://www.dropbox.com/s/2jb62pmfcy4ea5k/Flexible-Scoring.pbix?dl=0
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Thank you so much!
I have tried the solution you have given and it's was fine, though when I applied it to my actual data it doesn't get what I wanted. I think my explanation was bad, my apologies about it.
In lieu with that please see this link https://www.dropbox.com/scl/fi/vcj58m3lcxw7qyyytsgw7/data_new.xlsx?dl=0&rlkey=gxtgucrt0qrtt3s3s54nkv0if for the excel file to what I really want to happen (column G-H) and how I want it to work.
Again my apologies and thank you for your support.
- amitchandak
I think if the issue with the filter applied. This what you need to do. As we are using a simple table to get the overall average, we are forced take all of that table means the filter will not apply. Now create a date table and join with your date. Also, create an employee and Supervisor, using summarize of distinct and try. That should help.
- amitchandak
I did some data modeling. Please download the file from same location and try.