cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
macg1976 Frequent Visitor
Frequent Visitor

multiple graphic filters

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

ProjectRiskButgetWeight budget (calculated column)ZoneWeight budget risk and zone (calculated column)
Project1A1000,256N0,556
Project2A800,205N0,444
Project3A1200,308S0,571
Project4A900,231S0,429
Total risk A 3901,000  
Project7C800,182W0,471
Project8C900,205W0,529
Project9C1300,295N0,481
Project10C1400,318N0,519
Total risk C 4401,000  
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: multiple graphic filters

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:

weight.png

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: multiple graphic filters

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:

weight.png

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!