cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tontaube2
Helper IV
Helper IV

Matrix - bars AND symbols

Hi,

 

does somebody have a suggestion/ can help me find my error?

 

A matrix depicts bars depending on the overall percentage ONE company got in different sectors (e.g. 90% in governance, 60% in economics...). BewertungsAnteil = SUM(Indikatoren[BewertungKPI])/SUM(Indikatoren[GewFaktor]).

This works fine.

 

But now I want to add symbols depending on another measure.

 

1.png

 

 I want to generate a green circle for 75-100% fulfillment, yellow for 50-75%... of ALL companies - not only of the selected one.

However, I do not manage to get the proper formula for that measure.

Maxbewertungsanteil = (BewertungsAnteil/SUMX(BewertungKPI)) does not give me the proper results.

 

Can anyone help me solve this "blockade" of my brain?

1 ACCEPTED SOLUTION
yingyinr
Community Support
Community Support

Hi @Tontaube2 ,

Could you please provide some sample data and your expected result with specific example and calculation logic?  Did you apply the field Indikatoren[BewertungKPI] and Indikatoren[GewFaktor] on the matrix? What do you mean about the below word?


 I want to generate a green circle for 75-100% fulfillment, yellow for 50-75%... of ALL companies - not only of the selected one.

However, I do not manage to get the proper formula for that measure.

Maxbewertungsanteil = (BewertungsAnteil/SUMX(BewertungKPI)) does not give me the proper results.


For example:

BewertungKPI GewFaktor Maxbewertungsanteil
0.25 0.42 ???
0.34 0.18 ???

 

If we have the data in above table, what should be the correct return value of Maxbewertungsanteil? Maxbewertungsanteil=(0.25/0.42)/(0.25+0.34) or something else?

Best Regards

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

View solution in original post

2 REPLIES 2
yingyinr
Community Support
Community Support

Hi @Tontaube2 ,

Could you please provide some sample data and your expected result with specific example and calculation logic?  Did you apply the field Indikatoren[BewertungKPI] and Indikatoren[GewFaktor] on the matrix? What do you mean about the below word?


 I want to generate a green circle for 75-100% fulfillment, yellow for 50-75%... of ALL companies - not only of the selected one.

However, I do not manage to get the proper formula for that measure.

Maxbewertungsanteil = (BewertungsAnteil/SUMX(BewertungKPI)) does not give me the proper results.


For example:

BewertungKPI GewFaktor Maxbewertungsanteil
0.25 0.42 ???
0.34 0.18 ???

 

If we have the data in above table, what should be the correct return value of Maxbewertungsanteil? Maxbewertungsanteil=(0.25/0.42)/(0.25+0.34) or something else?

Best Regards

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

Hi Rena,

 

I apologize for the late reply & the late Kudos. A different project "crashed into the forefront" - and the one mentioned above was grounded for the time being. Now I am back.

Next week I`ll produce some sample data and expected results - or even post additional details...

 

Bye

 

Michael

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors