cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
abisaileon11 Regular Visitor
Regular Visitor

How to calculate percentage per year

Hi, 
I'm working on a report of sales from last year to know.
I created a measure that shows me the percentage of sales of each product from the grand total but Now I have information of 2019 and this measure sums all units solds from 2018 and 2019

 

% VENTAS TOTALES DEL AÑO = sum(Consolidado2018[UNIDADES])/sumx(all(Consolidado2018),Consolidado2018[UNIDADES])

So what I need is a new measure that shows me the percentage of sales of 2018 when I select 2018 and 2019.

Hope you can help me. 

Thank you

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to calculate percentage per year

@abisaileon11,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: How to calculate percentage per year

@abisaileon11,

 

You may refer to the following post.

https://community.powerbi.com/t5/Desktop/Subtotal-Percentages/m-p/313658#M139139

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.