Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Amount in Matrix Is Not the Same with Chart

Does anyone know why I don't recognize the amount correctly?

On the one hand I have the following matrix, as you can see, the operator Edgar has 15%. To create this array I have a table that is not connected to the general schema and I use the Array Warehouse Entries measure to add values:

Matriz Entradas almacen = 

VAR calc = IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Edgar" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="%",FORMAT(DIVIDE(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=4),CALCULATE([PickingEntradas],REMOVEFILTERS(matriz_entradas_almacen))),"Percent"))
Return
calc

Now what I want to do is show those same results on a line graph and what it does to me is the following:

Does anyone know why I get a 1.00 when I should get 15%? In this case, the measurement I use is

Select Entradas Graficos = 
VAR SelectIndicador = SELECTEDVALUE(matriz_entradas_almacen[nombre])

Return
SWITCH(TRUE(),
SelectIndicador="Edgar Rodas",[%PickingEntradas3]
)

The measure [%pickingEntradas3] is the same as the previous one :

FORMAT(DIVIDE(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=4),CALCULATE([PickingEntradas],REMOVEFILTERS(matriz_entradas_almacen))),"Percent")

Thank you.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, Syndicate_Admin 

    Congratulations on solving your problem, it's a real joy.

     

    Best Regards

    Yongkang Hua