data don't load
1 Topic
Distincount wiht slicer
Hi guys, i have a two tables: Entradas (Which has "Año de Ingreso" Column) Desembolsos (Which has "Nro_Operaciones" and "Año Desembolso" column) I need a measure that do Distintcount of "Nro_Operaciones" base on a slicer "Año de Ingreso" I did this measure: Operaciones Desembolsadas por Año = VAR _A= SELECTEDVALUE(Entradas[Año Ingreso]) RETURN CALCULATE(DISTINCTCOUNT(VW_BT_Desembolsos[Nro_Operacion]),FILTER(ALL(VW_BT_Desembolsos),VW_BT_Desembolsos[Año Desembolso]=_A)) It works well if I select only one year in my slicer, but when i have two years selected or none the result is blank. What am i missing?? Thansk!Solved2.2KViews0likes1Comment