Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The data looks similar to this:
A | B | C | D | E | F |
A | 1.86 | 5 | 9.3 | 13.5 | 6.89 |
A | 0 | 0 | 0 | 13.5 | 0.00 |
A | 0 | 2 | 0 | 13.5 | 0.00 |
B | 2.4 | 5 | 12 | 13.5 | 8.89 |
B | 0 | 0 | 0 | 13.5 | 0.00 |
B | 0 | 2 | 0 | 13.5 | 0.00 |
C | 2.5 | 5 | 12.5 | 13.5 | 9.26 |
C | 0.1 | 10 | 1 | 13.5 | 0.74 |
C | 0 | 2 | 0 | 13.5 | 0.00 |
Column E represents the Max Sum Value which is Line C 12.5 + Line C 1 = 13.5
Goal 1: Create Dax Expression that caluclates the Max Sum by Line (Column A)
Goal 2: New measure to calculate Sum by Line divided by Max Sum Value multiplied by 10.
The end result is a normalized weighted value by Line A, Line B, Line C
Solved! Go to Solution.
I hope that I understood this correctly
Max Sum Value = MAXX( SUMMARIZE( ALL('Table'); 'Table'[A]; "Total";SUM('Table'[D]) ); [Total] )
and
Weighted Sum Value = DIVIDE(SUM('Table'[D]);[Max Sum Value])*10
I hope that I understood this correctly
Max Sum Value = MAXX( SUMMARIZE( ALL('Table'); 'Table'[A]; "Total";SUM('Table'[D]) ); [Total] )
and
Weighted Sum Value = DIVIDE(SUM('Table'[D]);[Max Sum Value])*10
Thank you for @Kristjan76. I can somewhat follow the expression, but not understanding where the "Total" comes from in the expression. Currently I am getting error that "Too few arguments were passed to the SUMMARIZE function. The minimum argument count for the function is 2."
My expression lools like this:
Max Sum Value = MAXX(SUMMARIZE(ALL(Concept,Concept[Route_A],"Total",SUM(Concept[D]),[Total])))
This should be a measure, not columns. And your ")" was in wrong places (in bold). The SUMMARIZE creates the column "Total". And once you have created the Total column, we take the Max value in that column.
Max Sum Value = MAXX( SUMMARIZE( ALL(Concept), Concept[Route_A], "Total",SUM(Concept[D]) ), [Total] )
To see how the summerize function work, press the "New Table" at the top and copy this into the function:
Table = SUMMARIZE( ALL(Concept), Concept[Route_A], "Total",SUM(Concept[D]) )
Please mark this as solved and give tumps up if it solves your problem.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |