Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create new table filtered

Hi! I am having troubles create a new filtered table, using column filters from other tables.   Example: This is the original table, I should get a filtered table from this Name  Product  Amount...
  • Singaravelu_R's avatar
    5 years ago

    Related two tables with Product,

    and add the calculated column 

    Product Result = if(ISBLANK( RELATED('Prodcut Master'[Product])),'Product'[Product])
    and in the result apply visual level or page level filter to only values