Forum Discussion

IPGeorgiev's avatar
IPGeorgiev
Helper III
6 years ago
Solved

Calculated field/ Divide - pivot table

Hi all,

 

I need support with something, I assume, pretty easy, however no matter what I try I dont get the results I want.

 

heres what I have in Power BI as Pivot Table: 

 

 

NOR and YESR those are SUM of values -

 

I want to add a new column to the pivot table displaying the following result - 54.5%

 

Which means I need the following formula - =YESR/(YESR+NOR)

 

However I am unable to get this value 54.5% and I get all kind of other values 😞


thanks in advance! 

Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi IPGeorgiev ,

     

    You need to configure the range of caiculation. You could refer to the following measure.

    Measure Y =
SUMX ( ALLEXCEPT ( 'TestTable', 'TestTable'[Agent] ), 'TestTable'[yesr] )
    / SUMX (
        ALLEXCEPT ( 'TestTable', 'TestTable'[Agent] ),
        'TestTable'[nor] + 'TestTable'[yesr]
    )

    Then set this measure as percentage style. 

     

2 Replies