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.      ...
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