Percentage of all revenue measure

[Anonymous]

Hello guys, I've got a measure called MONTHSUM which returns the sum of the last month, and another one called REVENUESUM which returns the total sum. What I want is the percentage of revenue of MONTHSUM, so I divided MONTHSUM / REVENUESUM and configured the cardchart to give percentage value, but it returns 100%. I wanted it to return the percentage of all revenue, like december revenue is 0.04% of all revenue ,something like that

[ryan_mayu]

@Anonymous

Do you have a month slicer to make the monthsum show as the correct value?

If not, I think you can try

= Divide( calculate([monthsum], FILTER(table, table[month]="December)), [REVENUSUM])

Hope this is helpful. thanks.

[Anonymous · Accepted solution]

Hey Ryan, thanks for you answer! I've just discovered the problem, it was only necessary to click on the percentual button located on the ribbon, so simples haha, it's because I'm new in power Bi, but thanks anyway

[v-cherch-msft]

Hi @Anonymous

Glad to hear that you've solved it, please accept your solution to close this thread.

Regards,

Cherie

[themistoklis]

@Anonymous

Try something like the following:

Measure =DIVIDE( [MONTHSUM], calculate( [REVENUESUM], all(table[MONTHS] )))

[Anonymous]

It does divide, but when I put on the card chart and turn into percentage it brings me 100% which is not true