Forum Discussion
Helper IICalculated Column is not returning any results
Hi kg4u
HotChilli is right here. I would create measures rather then calculated columns, then they can be used all over your model.
Set up following measures:
Tot Recorded Call Score = SUM('Facts'[Total Recorded Call Score])
Tot Prod Desc Score = SUM('Facts'[Total Prod Desc Score])
Tot Payment Score = SUM('Facts'[Total Payment Score])
Scripting Score = [Tot Recorded Call Score] + [Tot Prod Desc Score] +[Tot Payment Score]
Similar logic for Points.
Then Scripting Rating = DIVIDE([Scripting Score], [Scripting Points])
The difference here between a column and a measure is that the calculated column leaves the calculation static and you'd end up adding individual scripting rating results. WIth a Measure you can apply it to any visual and it will work within the context of that visualDid I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!
Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181
Helper III ultimately want to use the Grand Total in another calculation. Please review the scenario below and let me know if there is a possible solution to what I am trying to accomplish. Thank you.
Scripting Score = 'Facts'[Total Recorded Call Score] + 'Facts'[Total Prod Desc Score] + 'Facts'[Total Payment Score]
Scripting Points = 'Facts'[Total Recorded Points] + 'Facts'[Total Prod Desc Points[ + 'Facts'[Total Payment Points]
Scripting Rating = DIVIDE([Scripting Score], [Scripting Points])
Resolver IIIHi kg4u
HotChilli is right here. I would create measures rather then calculated columns, then they can be used all over your model.
Set up following measures:
Tot Recorded Call Score = SUM('Facts'[Total Recorded Call Score])
Tot Prod Desc Score = SUM('Facts'[Total Prod Desc Score])
Tot Payment Score = SUM('Facts'[Total Payment Score])
Scripting Score = [Tot Recorded Call Score] + [Tot Prod Desc Score] +[Tot Payment Score]
Similar logic for Points.
Then Scripting Rating = DIVIDE([Scripting Score], [Scripting Points])
The difference here between a column and a measure is that the calculated column leaves the calculation static and you'd end up adding individual scripting rating results. WIth a Measure you can apply it to any visual and it will work within the context of that visual
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! Happy to help!!
Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181