Staked Bar Visual problem (using measures)

[ArquimedesP]

Hi, i have a problem with visuals. I have a table (Desembolsos) wich contains values like this :

Cuit	Cliente	Monto M.N. (Millones)	Nro Operación	Producto	Women	Exportadores	Proyecto Social
452456255	Fulanito	100	2828	1	N	S	N
455456455	Perencita	200	38373	1	S	S	S
987521456	Menganita	300	54675	2	S	N	S
987265554	Carlitos	400	3736	3	N	N	N

I create two tables (no related to Desembolsos) the contains:

YES/NO

S

N

Tipo

Exportador

Mujeres

Proyecto Social

Then I used stacked visual to counts distinc operations in "Desembolsos" for "Tipo" when YES or NO. I used this measure:

Operaciones_Tipo_PRUEBA = 
VAR _A= SELECTEDVALUE('Agrup. Varios'[Tipo],"Mujeres")
VAR _B= SELECTEDVALUE('Agrup.YES_NO'[YES/NO],"N")
VAR _C= SELECTEDVALUE('Agrup.YES_NO'[YES/NO],"S")

RETURN

IF(_A="Mujeres" && _B="N",CALCULATE(DISTINCTCOUNT(VW_BT_Desembolsos[Nro_Operacion]),VW_BT_Desembolsos[Women]="N"),CALCULATE(DISTINCTCOUNT(VW_BT_Desembolsos[Nro_Operacion]),VW_BT_Desembolsos[Women]="S"))

I got result as i spect it, but when i select in the visual the result Yes or No my other visuals don't change according to that, and when i select in my other visuals the stacked change normally.

What can it be? My interactions are Ok.

Thanks a lot!

[lbendlin]

This behavior normally indicates that the data model does not support your business question. Check the arrows in your data model.