The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
78 | |
77 | |
36 | |
32 | |
29 |
User | Count |
---|---|
91 | |
79 | |
57 | |
48 | |
48 |