Adding the Value of Two Textboxes in Separate Tables

Hi Anonymous ,

Create Custom Code Functions: You can write custom functions to aggregate your values.

Modify Your Textbox Expressions: Use the function within your existing expressions for Textbox10 and Textbox20 to add their values to the total. For example, for Textbox10, modify the expression.

=Code.AddToTotal(SUM(IIF(DateAdd("m", 1, Parameters!Quarter.Value) = Fields!Exit_Date.Value, Lookup(Fields!Investment.Value, Fields!Investment.Value, Fields!Recallable_Amount.Value, "SumInvestmentsMeasures"), 0)))

 To display the aggregated value, you can create another textbox and set its expression to . This textbox will display the sum of the values from Textbox10 and Textbox20.=Code.GetTotal().

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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