Format Background Color by Comparing Values in One Column

[third_hicana]

Hello. I woud appreaciate your help regarding my scenario. I was not able to get the right solution.

I want to compare the 'Value' per 'Money" type if the value of projects (ID Level 2) exceeds to its associated BOP in ID Level 1 column. If value of projects per money type exceeds the value of BOP per 'Money" type, font color is red. If it does not exceed make it color black.

In my example data below totals per Money" type of projects BOP23-016-B and BOP23-016-B exceeds the CAPEX, OPEX and TOTAL of ID BOP23-016. Total Capex of projects is 70 which exceeded 8 of BOP Capex. The same principle applies to OPEX and TOTAL.

While BOP25-003-B project values for CAPEX, OPEX and TOTAL is below to the values of BOP BOP25-003.

ID Level 1	ID Level 2	Money	Value	Tagging
BOP23-016		TOTAL	67.21	BOP
BOP23-016		CAPEX	8.00	BOP
BOP23-016		OPEX	59.21	BOP
BOP23-016	BOP23-016-B	TOTAL	91.00	Project
BOP23-016	BOP23-016-B	CAPEX	25.00	Project
BOP23-016	BOP23-016-B	OPEX	66.00	Project
BOP23-016	BOP23-016-C	TOTAL	137.00	Project
BOP23-016	BOP23-016-C	CAPEX	45.00	Project
BOP23-016	BOP23-016-C	OPEX	92.00	Project
BOP25-003		TOTAL	180.00	BOP
BOP25-003		CAPEX	80.00	BOP
BOP25-003		OPEX	100.00	BOP
BOP25-003	BOP25-003-B	TOTAL	40.00	Project
BOP25-003	BOP25-003-B	CAPEX	20.00	Project
BOP25-003	BOP25-003-B	OPEX	20.00	Project

Screenshot of Sample Data

Appreciate your help. Thank you.

[BIswajit_Das · Accepted solution]

Hello @third_hicana 
You can create a measure as per your conditions
Step1 - Need to figure the [Value] where the [Tagging] IN {"BOP"} as per [ID Level 1] & [Money]

Step2 - Need the sum of [Value] for the [Tagging] IN {"Project"} as per [ID Level 1] & [Money]
Step3 - Add the condition Step2 > Step1 then Return "RED" else "BLACK"
Here's the complete DAX

Thanks & Regards...

[third_hicana]

@BIswajit_Das 

Superb. Thank you very much for your help 🙂 

[BIswajit_Das]

Hello @third_hicana 
Is your result table gonna be something like this ?

Thanks & Regards...

[third_hicana]

Hi @BIswajit_Das 

Yes.

May I know how did you do this in DAX?