Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ArquimedesP
Helper I
Helper I

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 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors