Whole numbers and percentages when joining measurements with a slicer.
Thursday
Hello community members, I use a combination of SELECTEDVALUE and SWITCH, to make a slicer, so far so good, the problem is that the measures are percentages and numbers, and when using the _KPIs measure or I select percentage or number. Do you know any way to solve this?
_KPIs =
var _Filtro = SELECTEDVALUE(Medidas_Filtro[Medida])
return
SWITCH(_Filtro, "# Answered", SUM(tb_CSR[# Answered]),
"AHT", SUM(tb_CSR[AHT]),
"% RCR", SUM(tb_CSR[% RCR]),
"% CSAT Response Rate", SUM(tb_CSR[% CSAT Response Rate]),
"% CSAT", SUM(tb_CSR[% CSAT]),
"% CRES Response Rate", SUM(tb_CSR[% CRES Response Rate]),
"% CRES", SUM(tb_CSR[% CRES]),
"% CES", SUM(tb_CSR[% CES]),
"% Abandoned Skill", SUM(tb_CSR[% Abandoned Skill]),
"% SLA", SUM(tb_CSR[% SLA]), "Selecciona un Filtro")
Thank you and greetings.
