Disconnected Table Calculations w/ Multiple Filter Selections

[Anonymous]

I have a table where columns are various months, rows are various products, products belong to various categories, and data is filtered for one or more regions. I'd like to divide these numbers for the total for the categories (all products).  In effect, dividing the table values by what would be reported for all products for the categories which are implicitly selected. What would be the dax for this formula?

[Anonymous · Accepted solution]

Figured it out... ALL function is great at removing specific filters.

Base Weighted Imageries = DIVIDE(sum('0 - Metrics'[Weighted Respondent Count]),calculate(sum('0 - Metrics'[Weighted Respondent Count]),ALL('NGBEV360 a - Imageries'[Imagery]),ALL('NGBEV360 a - Imageries'[Brand])))