Forum Discussion

grijs's avatar
grijs
Frequent Visitor
10 years ago
Solved

Filter on unrelated table

I have two unrelated tables in Power BI: Table 1: Experiment information Columns: Experiment name, Start Date, End Date   Table 2: Measurements Columns: Date, Measurement   I created a filter ...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    grijs

     

    What about a calculated table? You can use the two visuals basing on the same calculated table.

     

    Table =
FILTER (
    CROSSJOIN ( 'Experiment information', 'Measurements' ),
    Measurements[Date] >= 'Experiment information'[Start Date]
        && Measurements[Date] <= 'Experiment information'[End Date]
)

     

Eric_Zhang's avatar
Eric_Zhang
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

grijs

 

What about a calculated table? You can use the two visuals basing on the same calculated table.

 

Table =
FILTER (
    CROSSJOIN ( 'Experiment information', 'Measurements' ),
    Measurements[Date] >= 'Experiment information'[Start Date]
        && Measurements[Date] <= 'Experiment information'[End Date]
)