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 Y...
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. 

     

v-eachen-msft's avatar
v-eachen-msft
Community Support
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.