multiple graphic filters

[macg1976]

Hello friends, I need help with the following: I work with a portfolio of projects that has several classifications: Risk, zone, project manager, etc. The issue is that I must calculate the relative weight of these projects according to the different classifications. said relative weight varies with the classification form. For example, I need the relative weight of each project in a certain zone and risk. For this I have tried to filter through the common filters in the graphical report part of power BI but it does not take the correct weight. I think you should build columns that filter according to pre-established forms. 

I attach an example table, with the calculated columns that I need in the graphic filters. In specific I need to generate multiple filters that allow to graphically show the correct relative weight, for example Weight budget risk and zone

Project	Risk	Butget	Weight budget (calculated column)	Zone	Weight budget risk and zone (calculated column)
Project1	A	100	0,256	N	0,556
Project2	A	80	0,205	N	0,444
Project3	A	120	0,308	S	0,571
Project4	A	90	0,231	S	0,429
Total risk A		390	1,000
Project7	C	80	0,182	W	0,471
Project8	C	90	0,205	W	0,529
Project9	C	130	0,295	N	0,481
Project10	C	140	0,318	N	0,519
Total risk C		440	1,000

[MFelix · Accepted solution]

Hi @macg1976 ,

You need to create a measure base on the type of Weigh you want to calculate looking at the your data you would need to add the following two measures:

Weight Risk =
SUM ( Projects[Budget] )
    / CALCULATE ( SUM ( Projects[Budget] ); ALLEXCEPT ( Projects; Projects[Risk] ) )


Weight Zone Risk =
SUM ( Projects[Budget] )
    / CALCULATE (
        SUM ( Projects[Budget] );
        ALLEXCEPT ( Projects; Projects[Zone]; Projects[Risk] )
    )

As you can see below the result is as expected:

Regards,

MFelix