# 6. Insert measure from bridge

Just like we inserted rows, we can also insert data input measures from one visual into another visual. We will demonstrate this with an example.

Consider two reports: one that has the employee salary details at the lowest hierarchical level (Org > Dept > Job Title > Employee > Salary) and another that has the aggregated salary data rolled up to the department level (Org > Dept).

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1912).png" alt=""><figcaption><p>Source visual</p></figcaption></figure>

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1913).png" alt=""><figcaption><p>Target visual</p></figcaption></figure>

Let us assume we want to include the data input measure 'Additional Bonus', from the first visual to the second visual. Here are the steps involved:

**STEP 1:** Create a bridge with the source visual using the steps illustrated [here.](https://docs.fabricplan.com/infobridge/pages/SwliBW8cfMAgmOF5LQFJ#id-1.-through-inforiver-console) The bridge is created as below:

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1914).png" alt=""><figcaption><p>Bridge with source visual</p></figcaption></figure>

**STEP 2:** Perform the required transformations on the bridge source, if necessary.

In this example, we need to remove the row categories from the source that are not present in the target visual. Click on **Pivot Table**, remove the categories and click **Apply**.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1915).png" alt=""><figcaption><p>Remove row categories</p></figcaption></figure>

The result is shown below. Note that we need to insert the highlighted data input measures into the target visual.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1916).png" alt=""><figcaption><p>Source visual - transformed</p></figcaption></figure>

**STEP 3:** Map the dimensions between the source and the target visuals for integration. The steps are illustrated [here.](https://docs.fabricplan.com/infobridge/pages/M0gdRdBqWTFZrCz20tgr#id-2.-mapping-dimensions-between-the-reports)

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/Mapping%20infob.gif" alt=""><figcaption><p>New integration and mapping</p></figcaption></figure>

**STEP 4:** Using **Insert Measure** option, insert the measures into the target visual.

1. Click on **InfoBridge ->** **Insert Measure** In the target visual. You can also use **Data Input -> Import from Infobridge** to insert an Infobridge measure.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1920).png" alt=""><figcaption><p>Import from Infobridge</p></figcaption></figure>

2. In the side panel, select the required mapping from the dropdown, the measure to be included, and click **Create.**

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/insert%20measure%20infob.gif" alt=""><figcaption><p>Measure inserted</p></figcaption></figure>

3. The measure is now inserted. It can be managed similar to Planning sheet's data input measure.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(1917).png" alt=""><figcaption><p>Manage Infobridge measure</p></figcaption></figure>

{% hint style="info" %}
Measures sourced from a bridge are read-only and cannot be directly edited. Values can be updated via the [adjustment workflow](/infobridge/11.-collaborative-adjustments.md).
{% endhint %}

### Viewing lineage

Navigate to Manage Columns and click the <img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(236).png" alt="" data-size="line">icon to view and directly navigate to the source bridge and query. This enables you to trace and manage rows inserted from different bridges.

<figure><img src="https://github.com/lumelinc/PowerTableDocs/blob/main/.gitbook/assets/image%20(237).png" alt=""><figcaption><p>Measure lineage</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.fabricplan.com/infobridge/6.-insert-measure-from-bridge.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
