locked
Calculated columns RRS feed

  • Question

  • Using a simple division I'm trying to show a A / B give C% in a Powerpivot table.

    My Dax formula can do this no problem, but when I add to my Power pivot it sums the Client %.

    Now, if I wasn't using the DataModel I would use a simple 'Calculated field' from the Powerpivot menu but it's greyed out.

    Can anyone advise how best to do this using the Data Model?

    Thanks.


    • Edited by Mike-Bishop Monday, November 10, 2014 10:40 AM
    Monday, November 10, 2014 10:39 AM

Answers

  • to do this, you have to create the C% as a measure in the data model, not as a calculated column.

    you can create the following measures:

    • total A:=calculate(sum([A]))
    • total B:=calculate(sum([B]))
    • C%:=calculate([total A] / [total B])

    regards,

    Driezl

    • Proposed as answer by driezl Friday, November 14, 2014 7:53 AM
    • Marked as answer by Mike-Bishop Friday, December 5, 2014 4:38 PM
    Friday, November 14, 2014 7:53 AM