Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Target Value for Gauge Metric When Filtering

Hr/Lin KM = var t= SUMMARIZE('Table1','Table1'[Pass], "Sum KM",SUM('Table1'[Linear KM]), "Sum Time",SUM('Table1'[Hours])) return SUMX(t,[Sum Time]/[Sum KM]) I currently have the above formula in r...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous

If my understanding is correct, you want the target value keeps the same value regardless of the selection from the slicer.

Based on your previous measure, create a column

column = var t=SUMMARIZE('Table1',Table1[Pass],"Sum KM",SUM(Table1[Linear KM]),"Sum Time",SUM(Table1[Time]))
         return SUMX(t,[Sum Time]/[Sum KM])

Then create measures

Measure = var t=SUMMARIZE('Table1',Table1[Pass],"Sum KM",SUM(Table1[Linear KM]),"Sum Time",SUM(Table1[Time]))
          return SUMX(t,[Sum Time]/[Sum KM])

Measure 2 = IF(HASONEVALUE(Table1[Pass]),[Measure],MAX([column]))

 

 

Best Regards

Maggie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

This still doesn't quite get me where I want.

 

I still want it to be a dynamic target, depending on filtering. 

 

If I filter by a single task, then I want the target to stay as if it were counting all values of all the tasks, but if i filter by a value on the pie chart, I want the target for that to be for all the tasks of that single value.