Need help with this filter and table link

Hi Anonymous ,

You couldn't have a calculated table or column interacted with a slicer or interaction , since calculated table or columns are only calculated when data is loaded/refreshed. 

To achieve your demand, you may needn't to create another calculated table3, just create measure like DAX below in Table1, then display Table1[Category], Table1[Type], Table1[Value] and Table1[%_Result] in table visual.

%_Result= 

Var _LastValue=  CALCULATE(SUM('Table1'[Value]),FILTER(ALLSELECTED('Table1'),'Table1'[Category]=MAX('Table1'[Category]) &&'Table1'[Type]=MAX('Table1'[Type])&&'Table1'[Index]=MAX('Table1'[Index])-1))

Var _Percent= DIVIDE( MAX('Table1'[Value]), _LastValue )*100

Return

IF(_LastValue<> BLANK(), _Percent , 0)

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.