Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I have the following matrix that I take from this measurement:
Medidas matriz almacen =
VAR calc = IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Albert" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="Entradas",FORMAT(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=6),"General Number"),IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Albert" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="%",FORMAT(DIVIDE(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=6),CALCULATE([PickingEntradas],REMOVEFILTERS(matriz_entradas_almacen))),"Percent"),IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Iván" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="Entradas",FORMAT(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=2),"General Number"),IF(SELECTEDVALUE(matriz_entradas_almacen[nombre])="Iván" && SELECTEDVALUE(matriz_entradas_almacen[descripcion])="%",FORMAT(DIVIDE(CALCULATE([PickingEntradas],Cab_act_almacen_reg_sql[Cod_ operario almacen]=2),CALCULATE([PickingEntradas],REMOVEFILTERS(matriz_entradas_almacen))),"Percent"))))
Return
calc
Table matriz_entradas_almacen is an isolated table that has no relation to any other table.
Now what I would like is the same but with a line graph but what it does to me is different. In fact, as you can see in the image, it only takes the values of three "operators" but not the rest as it does in the matrix. I imagine that the above measurement that I use for matrix is not useful for graph.
Can you help me?
Thank you.
@Syndicate_Admin , if you are using two measures, you should use them two y-axis. One line on each Y-axis- Primary and seconday
User | Count |
---|---|
83 | |
69 | |
68 | |
65 | |
54 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |