Measures as Filters

Hi , rrb2150 

I don't currently find a way to call a measure by using the measure name, But if we only have 4 measures, we can use the enumeration method to sum all the cases.

Here are the steps you can refer to :

(1)This is my test data , I create four measures :

(2)We need to create a table which contains the name of the measure and index column like this:

(3)We can create a measure like this:

Total Measure = 
var _rows =COUNTROWS( VALUES('MeasureName'[Name]))
var _value = SUM('MeasureName'[Index])
var _index = VALUES(MeasureName[Index])
return 
SWITCH(  TRUE(),
_rows = 4 , [Measure1]+[Measure2]+[Measure3]+[Measure4],
_rows = 3 , IF( _value =6 , [Measure1]+[Measure2]+[Measure3] , IF( _value =7 , [Measure1]+[Measure2]+[Measure4] , IF( _value = 8 ,[Measure1]+[Measure3]+[Measure4] ,[Measure2]+[Measure3]+[Measure4]))),
_rows =2 , IF( _value=3 ,[Measure1]+[Measure2] , IF(_value=4 ,[Measure1]+[Measure3] , IF( _value =5 && 1 in _index ,[Measure1]+[Measure4] , IF( _value =5 ,[Measure2]+[Measure3] ,IF(
    _value=6,[Measure2]+[Measure4] , IF( _value=7 ,[Measure3]+[Measure4])))))),
_rows=1 , SWITCH( _value ,1,[Measure1] ,2 ,[Measure2] ,3,[Measure3] ,4,[Measure4]))

(4) Then we can meet your need , the result is as follows:

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly