Matrix: Conditional formatting values using measure

[Richard_Halsall]

Hi

I am struggling to conditionally format a matrix field with a measure.

Data table

The measure I have written

Measure =

var projectend = MAX('FactDemandAllocationWith Certs'[ProjectEndDate])

var certificatend =MAX('FactDemandAllocationWith Certs'[End_Date__c])

var certificatedate = FORMAT(MAX('FactDemandAllocationWith Certs'[HasCertDate] ), "Standard")

var result =

SWITCH(

    TRUE(),

    certificatedate = "0"  , "red",

    projectend > certificatend, "blue",

    "green"

)

RETURN result

Matrix with measure in values section

 

Matrix with measure removed from values section

I would like the matrix to be coloured as the first example but without having to use the measure in the values

Any help would be appreciated. Thanks

[lbendlin]

To report on things that aren't there you need to use disconnected tables and/or crossjoins.