Forum Discussion

ShaelynFrench's avatar
ShaelynFrench
Helper I
3 years ago
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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi ShaelynFrench

     

    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.

ShaelynFrench's avatar
ShaelynFrench
Helper I
3 years ago

amitchandak  Hi, yes I believe what you are suggesting works great for Matrix visuals, but I am not able to use it for other visuals. Here's a link to an example: Link 

  • v-jingzhang's avatar
    v-jingzhang
    Community Support
    3 years ago

    Hi ShaelynFrench

     

    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.