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

Hi,

I am not sure how your datamodel looks like, but in my opinion, slicer selection from the visualization is not influencing the result when creating physical calculated table. If you want to make it happen, one of ways is to insert the condition directly into the formula to create physical calculated table.

I hope this helps.

Thanks.

  • 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