Forum Discussion

pmdci's avatar
pmdci
Icon for Advocate V rankAdvocate V
10 years ago

gauge dynamic target

Hi,   I has a report with a radial gauge and a slicer for the weeks in the year.   I have a target of 5000 units per week. So if I select only one week on the slicer, I want to see 5000 as the ta...
Need Help
JPC3's avatar
JPC3
Icon for Advocate I rankAdvocate I
10 years ago

Assuming that you already have a Week column in your dataset then you should simply be able to create a measure like,

 

  • TargetMeasure = DISTINCTCOUNT([WEEKCOLUMN])*5000

JC