Staked Bar Visual problem (using measures)

ArquimedesP — Mon, 27 Sep 2021 17:21:37 GMT

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

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!

Re: Staked Bar Visual problem (using measures)

lbendlin — Sun, 26 Dec 2021 21:22:50 GMT

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

topic Re: Staked Bar Visual problem (using measures) in DAX Commands and Tips

Staked Bar Visual problem (using measures)

Re: Staked Bar Visual problem (using measures)