Whole numbers and percentages when joining measurements with a slicer.

[fist]

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.

[JoeBarry]

Hi @fist 

maybe this post will help you ? https://community.fabric.microsoft.com/t5/Desktop/DAX-FORMAT-value-based-on-slicer-selection/m-p/212...

Thanks

Joe

If this post helps, then please Accept it as the solution