Forum Discussion

shkabuzar's avatar
shkabuzar
Frequent Visitor
8 years ago
Solved

Percentages to multi line report

Hi,    Here is the report which showing values, I would like to calculate percentages of it.   ex: for Nov 2018 A = 32 , B = 24  Expected results A=57.14%, B= 42.85%   Please let me know how t...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    shkabuzar,

     

    You may use measure below.

    Measure =
DIVIDE (
    SUM ( Table1[Count] ),
    CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) )
)
v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

shkabuzar,

 

You may use measure below.

Measure =
DIVIDE (
    SUM ( Table1[Count] ),
    CALCULATE ( SUM ( Table1[Count] ), ALLSELECTED ( Table1[Category] ) )
)
UNOFOR's avatar
UNOFOR
Frequent Visitor
6 years ago

Thank you very much. Thing it did the trick!

 

/U