cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Regular Visitor

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

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

1 ACCEPTED SOLUTION
Community Support

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.

Community Support

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.

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors