Power Platform Community Forum Thread Details

Hello everyone,
I'm currently building a risk matrix and trying to filter it based on probability of occurrence and impact. My gallery looks like this:

In the Items property I have the following:

Distinct(Risikobewertung;Projekt)

I determine the numbers in the respective text property as follows:

CountRows(Filter(Risikobewertung;Eintrittswahrscheinlichkeit * Schadensauswirkung <=4)) (for example)

Now I want the gallery to just show the number of each risk category, sorted by project. For example, project A has 1 green, 1 yellow and 1 red risk. The other projects have no green risk, etc. It currently shows the total number of risk categories found in all columns.

How can I filter this please?

Thanks in advance and greetings!

Categories:

Building Power Apps