Measure for Context Based Sales Calculation Not Showing Correct Total

Thanks for your response mark_endicott johnt75  weiqb 

Yes, creating a disconnected table is the only viable solution in this case. I implemented this approach using a field parameter, and it’s now working fine.

weiqb , ISFILTERED, ISINSCOPE, and ISCROSSFILTERED return the correct total only when the context comes from a single table. However, when the context comes from multiple tables, these functions do not work as expected for total calculations.

Thanks for insights🙏