Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
This behavior normally indicates that the data model does not support your business question. Check the arrows in your data model.
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
54 | |
35 | |
19 | |
18 | |
15 |