I have question on include/exclude dimensions in expression:
My current expression is below, this calculates the aveerage of the gross margin by country in a text box. I want this expression to only update when a country field is selected. There are other fields in the table such as customer, manager, employee etc. but I want this expression to update only for Country selected. Please advise how this can be achieved.
you can add 1 before set analysis and p() function for Country field: in this way, thanks to 1, no one selection will change expression, but p() function ensures you to change expression respect to selection on Country.