Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hola compañeros de la comunidad, uso una combinación de SELECTEDVALUE y SWITCH, para hacer un slicer, hasta ahi todo bien, el problema es que las medidas son porcentajes y numeros, y al utilizar la medida _KPIs o selecciono porcentaje o numero. conoceis alguna manera de poder solucionar esto??
_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")
Gracias anticipadas y un saludo.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |