Forum Discussion
Calculated Column is not returning any results
- 3 years ago
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
It's a context thing.
Measures are dynamic and should be used in visuals. Calculated columns are static and evaluated when powerbi loads.
It is possible to use measures in calculated columns but not recommended.