Forum Discussion
Solved
Slice Gauge Visual with Measure
Hi, I have a measure ("ProfDept") that determines what department an individual is currently in based on the slicer date. This measure cannot be added to the fact table as a calculated column sin...
Please try these new measures in your Gauge visual.
2020 Sales Measure = VAR Selection = SELECTEDVALUE('Sales Class'[Selection]) var _table = SUMMARIZE('Data','Data'[Customer],"_2020_sales",SUM('Data'[2020 Sales]),"_sales_class",[Sales Class]) return SWITCH(TRUE(), Selection = "All Customers",SUMX(_table,[_2020_sales]), SUMX(FILTER(_table,[_sales_class] IN VALUES('Sales Class'[Selection])),[_2020_sales]) )2021 Sales Measure = VAR Selection = SELECTEDVALUE('Sales Class'[Selection]) var _table = SUMMARIZE('Data','Data'[Customer],"_2021_sales",SUM('Data'[2021 Sales]),"_sales_class",[Sales Class]) return SWITCH(TRUE(), Selection = "All Customers",SUMX(_table,[_2021_sales]), SUMX(FILTER(_table,[_sales_class] IN VALUES('Sales Class'[Selection])),[_2021_sales]) )Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Please try these new measures in your Gauge visual.
2020 Sales Measure =
VAR Selection = SELECTEDVALUE('Sales Class'[Selection])
var _table = SUMMARIZE('Data','Data'[Customer],"_2020_sales",SUM('Data'[2020 Sales]),"_sales_class",[Sales Class])
return
SWITCH(TRUE(),
Selection = "All Customers",SUMX(_table,[_2020_sales]),
SUMX(FILTER(_table,[_sales_class] IN VALUES('Sales Class'[Selection])),[_2020_sales])
)2021 Sales Measure =
VAR Selection = SELECTEDVALUE('Sales Class'[Selection])
var _table = SUMMARIZE('Data','Data'[Customer],"_2021_sales",SUM('Data'[2021 Sales]),"_sales_class",[Sales Class])
return
SWITCH(TRUE(),
Selection = "All Customers",SUMX(_table,[_2021_sales]),
SUMX(FILTER(_table,[_sales_class] IN VALUES('Sales Class'[Selection])),[_2021_sales])
)
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
v-jingzhang this seems like a great solution, thanks!