create a percentage based on categories in multiple columns

[Anonymous]

so the data I have is similar to this;

category	volume	date	type
a	1	jan	group1
a	4	jan	group1
b	12	jan	group2
c	2	jan	group1
b	7	feb	group1
a	9	feb	group2
c	10	feb	group1
c	4	feb	group2
b	8	mar	group1
c	3	mar	group1
a	1	mar	group1
a	11	mar	group2

and I have a page level filter of type; group1. I would like a graph that represents the percentage of volume per category, per month. like this;

the best I have is;

measure=

divide(

Calculate(sum(table[volume]),allexcept(table,table[type],table[date])),

calculate(sum(table[volume]),allexcept(table,table[date])

)

the issue with this is that the allexcept function doesnt take into account filters. can anyone help with a solution?

thanks!

[Anonymous]

 sorry the graph didnt attach properly the first time, I need it to be a percentage of the total per month but without loosing the filter. something like this;

	A	B	C
JAN	71%	0%	29%
FEB	0%	41%	59%
MAR	8%	67%	25%

[edhans]

Can you be a bit clearer @Anonymous on what you need? Let's start with the table visual. Much easire to see what is happening then we can convert to a line or bar chart.

I have this right now:

But I am pretty sure that is not what you want. I see the measure you wrote, but you are just saying it doesn't work. if you could provide some expected output. Create a mockup in Excel using this data with the numbers you want and how the filter pane or slicers would/would not affect it it would be helpful. Screenshots for expected results is ok.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum