Gauge Segments

[plus9000]

Hello!

I would like to do the following, I have Columns called "Item-ID", "Item", "Supplier", "Supplier-ID", "Commodity-Group", "Commodity-Group-ID".

First I want to check, how many Supplier-ID's are connected with the Item-ID. So that means, are there more than 1 supplier? More than 2?

And finally show in segmented fields in a gauge the level of it. 

Level 1 = 1 Supplier, 100%, "extreme high"

Level 2 = 2 Suppliers, 75%, "high"

Level 3 = '>2' Suppliers, 50%, "moderate"

What I did so far was creating a KPI called "Measure_Supply" with the formula:

Solved it like this:

IF(GetSelectedCount([Artikel-ID]) = 0,0,

IF(Count(DISTINCT [Supplier-ID]) = 1, 100,
IF(Count(DISTINCT [Supplier-ID]) = 2, 75,
IF(Count(DISTINCT [Supplier-ID]) = 3, 50, 0))))

And maybe is there a option to set specific colors of the bar for the levels?

But it always just shows the accurate number of Suppliers. I would like to have it at 100, when 1 Supplier and so on considering the Levels.

Maybe some of your might help me.

Thanks!