Get a target by client in each row

[FernandoOliveir]

Hello everyone!

I have a table with operational result by client as you can see bellow:

At the momment the target is 15% for all of clients because it's the target of the segment, but my manager need to see a specific target per client. Is it possible?

I mean: 

For first client the icon target will be:

Bellow 8% will be green

8-9% will be yellow

10 or more will be red

For second client the icon target will be:

Bellow 18% will be green

18-19% will be yellow

20 or more will be red.

Thanks.

[v-stephen-msft · Accepted solution]

Hi @FernandoOliveir ,

You can create a measure for conditional formatting.

For example,

Color = 
VAR _per =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALLSELECTED ( 'Table' ), [Client] = MAX ( 'Table'[Client] ) )
    )
RETURN
    SWITCH (
        SELECTEDVALUE ( 'Table'[Client] ),
        "Client 1",
            IF (
                _per < 0.08,
                "CircleHigh",
                IF ( _per >= 0.08 && _per <= 0.09, "CircleMedium", IF ( _per > 0.10, "CircleLow" ) )
            ),
        "Client 2",
            IF (
                _per < 0.18,
                "CircleHigh",
                IF ( _per >= 0.18 && _per <= 0.19, "CircleMedium", IF ( _per > 0.20, "CircleLow" ) )
            )
    )

Reference: Tips on displaying icons based on field values in ... - Microsoft Power BI Community

Best Regards,

Stephen Tao

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

[FernandoOliveir]

Worked perfctly, but i have forget of a specific case.

I have one client that have four differents operations, and that ramification uses another value in the same table. I tried to adjust the DAX using chatgpt, but i couln't.

Thanks for the support and sorry for the delay to reply. I was working in others projetcs and only now back to this one.

Example: