cancel
Showing results for
Did you mean:
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.

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
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.
2 REPLIES 2
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.
Helper IV

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

Announcements