Forum Discussion

kg4u's avatar
kg4u
Icon for Helper II rankHelper II
3 years ago
Solved

Calculated Column is not returning any results

Hi,   I want to sum three measures to create a "Grand Total".  I thought I could accomplish this with a calculated column.  When I create the column, the results are empty.  What am I doing wrong? ...
  • BiNavPete's avatar
    BiNavPete
    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 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