Index weighting calculation

I am trying to perform an index weighting calculation, using the formula (Value in Cell * Grand Total of Grand Totals)/(Row Total * Column Total). This calculation is a custom measure.

The problem is that when applying a filter to a dimension this calculation is run against, the filter no longer has context for the grand total to work correctly.  What I am looking for is the ability for the grand total to ignore the filter context of the dimension. 

0 0 538
0 REPLIES 0
Top Labels in this Space
Top Solution Authors