Hi Nik, Create three different calculations(1.for red, 2. for blue and 3 for redblue) based on the color. Drag all measure values in rows shelf and measure names into color shelf. Later remove unused measures from existing measure values. Now change the default property of measure values to line. Hope this helps you. Thanks-Vamsi.
Unfortunately you lost me at “create three different calculations”… I don't know what the calculation syntax should be :-(
Sorry for being a bit dim.