Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Disconnected Table Calculations w/ Multiple Filter Selections

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?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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])))

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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])))