Conditional Formatting: How to get it working?

[Anonymous]

I have 2 data tabels and want to calculate a delta and give a conditional formatting to it. Only the last thing is not working. 

How should I do this?

DataSet1:

KPI	Value
Name 1	100

DataSet 2:

KPI	Value
Name 1	57

Measures:

KPI 1 =  CALCULATE(SUM(DataSet1[Value]);(DataSet1[KPI]="Name 1"))

KPI 2 =  CALCULATE(SUM(DataSet2[Value]);(DataSet2[KPI]="Name 1"))

KPIdelta = [KPI 1] - [KPI 2] 

Visual table:

[v-lili6-msft · Accepted solution]

hi, @Anonymous

It starts working as soon as you add a column DataSet1[KPI] in there.  I believe there needs to be a categorical variable in there even if it has only 1 value.

In your case, you could create a relationship between DataSet1 and DataSet2 by KPI field.

Then drag column DataSet1[KPI] into visual

Result:

Best Regards,

Lin

[Anonymous]

@v-lili6-msft Thanks! Sometimes solution are so simple but hard to figure out:)