Making the top level of a matrix red if any of the lower levels is negative

[Jorjor]

I have a matrix with item, item group and qty. I would like to make a conditional formatting that says that when a single item in the group is negative make the whole group red. Is this possible? Does it need dax?

[Anonymous · Accepted solution]

Hi @Jorjor ,

@Ritaf1983 , thanks for your concern about this case. I tried to create a sample data myself based on the user's requirement and implemented the result. Please check if there is anything that can be improved. Here is my solution: 

Based on your description, I created these data.

1. create MEASURE and find the value that is negative.

Test =
IF(
MAX('Table'[Value])<0,1,0)

2. create MEASURE, find the group with negative numbers and set it to red.

colour =
var _max=
MAXX(
FILTER(ALL('Table'),'Table'[Group1]=MAX('Table'[Group1])),[Test])
RETURN
IF(
_max=1, "red")

3. Create a conditional format. You can set where it is applied according to your needs.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[Ritaf1983]

Hi @Jorjor 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly