Forum Discussion

Raj12's avatar
Raj12
Icon for Helper III rankHelper III
2 years ago
Solved

Measure returning value from a connected table ignoring other table selection

Table 1 (LFSLTRNR) has monthly sales for an agent Table 2 (Agents Target) has monhtly target for an agent. Table 1 and 2 are connected via agent code   Report has Sale date filter from table1 and...
Need Help
Show and Tell
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Raj12's avatar
    Raj12
    Icon for Helper III rankHelper III
    2 years ago

    PFB data:
    Agents Target Table

    YearMonthSales Code Value
    20241Agent1515
    20241Rax4545
    20242Aga2323
    20242Agent1316
    20242Pag1212
    20242Rax6767
    20243Agent1751

     

    LFSLTRNR

    Agent CodeStrndtStrndt_Month  Strndt_Year
    AGA13/02/2024 00:00  22024
    Agent11/01/2024 00:00  12024
    Agent13/02/2024 00:00  22024
    Agent14/03/2024 00:00  32024
    Rax11/01/2024 00:00  12024