Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Visualisation not showing correct results from multiple tables

Hi, so im reletively new to powerbi but seem to be making good ground.   However I have an issue where im trying to have a visual bring back results from two different tables   Ive screenshot the...
  • ValtteriN's avatar
    ValtteriN
    2 years ago

    In the example I provided:

    Measure 32 =
    var _supplier = MAX('Table (42)'[Supplier]) RETURN
    CALCULATE(SUM('Table (41)'[Value]),'Table (41)'[Supplier]=_supplier)

    Here we take the supplier information from one table and use it to calculate the corresponding value from the other.
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Apologies if a simple question but how to you modify the filter context?

ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
2 years ago

In the example I provided:

Measure 32 =
var _supplier = MAX('Table (42)'[Supplier]) RETURN
CALCULATE(SUM('Table (41)'[Value]),'Table (41)'[Supplier]=_supplier)

Here we take the supplier information from one table and use it to calculate the corresponding value from the other.