Forum Discussion

powerx786's avatar
powerx786
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Making CALCULATETABLE filter by selected column

I have data like this in two tables as Table1 and Table2, with same columns      In my PowerBI report, I have two filters on Table1's Type and Table2's Type columns like below.      ...
powerx786's avatar
powerx786
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

There is nothing in the data model except two separate tables. There are no further relationships. The slicer in the report is directly referencing the column in the table. 

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Please try something like below to create a calculated table whether it suits your requirement.

 

Table4 =
UNION (
    CALCULATETABLE ( Table1, Table1[Type] = "A" ),
    CALCULATETABLE ( Table2, Table2[Type] = "A" )
)

 

  • powerx786's avatar
    powerx786
    Icon for Microsoft Employee rankMicrosoft Employee
    3 years ago

    I do not want to give an explicit value (Table1[Type] = "A") for the filter condition as I want to filter by the value selected in the filter visual