Link dynamic result in Table A to obtain a result from Table B

[EugeneK1]

Hi, hoping to get some help on this.

I have a ‘Variance’ measure in ‘Table A’ and would like to know the corresponding performance results from ‘Table B’ in a Card Visual.

Any suggestions to create the link ?

Example 1; Location Spring Valley’s variance is 13.85%, hence “Above Target”

Example 1

Example 2; County Houston’s variance is 9.45%, hence “On Target’

Example 2

Example 3; County Houston’s variance for month of Mar is -14.16%, hence “Below Target’

Example 3

In ‘Table A’ there are;

6 Columns; State, County, Location, Year, Month, Target, Actual

1 Measure:  Variance = ( Sum('Table A'[Actual]) - SUM('Table A'[Target]) ) / SUM('Table A'[Target])

Table A

In ‘Table B’ there are;

4 Columns; Performance, Variance, Min.Variance, Max.Variance

Table B

[v-yuta-msft · Accepted solution]

@EugeneK1 ,

You may create a new measure like below and drag that measure to another vard visual:

Target =
SWITCH (
    TRUE (),
    [variance] > 0.0945, "Above Target",
    [variance] = 0.0945, "On Target",
    [variance] < 0.0945, "Below Target"
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.