Forum Discussion

ArquimedesP's avatar
ArquimedesP
Helper II
4 years ago

Staked Bar Visual problem (using measures)

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

 

CuitClienteMonto M.N. (Millones)Nro OperaciónProductoWomenExportadoresProyecto Social
452456255Fulanito10028281NSN
455456455Perencita200383731SSS
987521456Menganita300546752SNS
987265554Carlitos40037363NNN



 

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!

 

1 Reply

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