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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors