Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
I converted the measurement to % value and it worked for me.
Hi, @Syndicate_Admin
Congratulations on solving your problem, it's a real joy.
Best Regards
Yongkang Hua
I converted the measurement to % value and it worked for me.
User | Count |
---|---|
121 | |
69 | |
66 | |
56 | |
52 |
User | Count |
---|---|
181 | |
85 | |
67 | |
61 | |
53 |