see the attached approach
first I tied the sum of the measure to the id with and lod
then changed the color code as shown
it returns this - i just showed several ids
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
TEST Color_v10.2.twbx 398.1 KB
Thanks Jim! Two days in a row!
Still Glad to help out