Matrix - bars AND symbols

[Anonymous]

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?

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ，

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

[Anonymous]

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