Forum Discussion
Measure for Context Based Sales Calculation Not Showing Correct Total
You could create a disconnected table containing the different types of table you are showing - City, Keyword match type etc. Add this as a filter to each table visual, selecting just the value applicable to that table.
Change your measure so that instead of using ISINSCOPE you check the SELECTEDVALUE of the disconnected table column, and then perform the appropriate calculation.
vm8181 - You won't be able to acheive this with ISINSCOPE - because that is always FALSE at the total level - without an incredibly horrendous final condition.
Honestly, the best way to acheive this is by modelling your data - I know you say this is not an option, but someone in your organisation can access the model and help you with it. A disconnected table that unions all your appropriate revenues together and then can be used as filter will make this 100 times easier than trying to solve with DAX alone.
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🙏