Hi all, I've been trying to create a DAX measure to generate scaled score (wihout intermediate tables) for a competition but unsuccessful.
This is how the end matrix is required in Power BI
The forumula that is used to calcuate the scaled score:
Scaled Score for an Activity = ((Sum of the respective Team's Activity Mins) - (Minimum of Activity Mins across teams)) /
((Maximum of Activity Mins across teams) - (Minimum of Activity Mins across teams))
For e.g., Scaled Score of Team 3 for Cooking = (150-20)/(205-20) = 0.703
This is the source table, named Activity: This table contains the list of activities (with duration in mins) perfomed by each candidate.
This is the measure I wrote after a lot of research, but it isn't working as intended
Scaled Score =
VAR MinValue =
VAR MaxValue =
VAR TeamTotal =
DIVIDE(TeamTotal - MinValue, MaxValue - MinValue, 0)
Any help in getting the DAX measure is appreciated. Thanks in advance!
Go to Solution.
View solution in original post
Thanks a ton @wdx223_Daniel! This is exactly what I wanted.
I was not aware of the ALL function, I'll research about its applications. Thanks again for the help.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.