Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Syndicate_Admin
Administrator
Administrator

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

apenaranda_0-1716455847274.png

apenaranda_1-1716455861237.png

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

apenaranda_2-1716456099616.png

apenaranda_3-1716456128974.png

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.

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

I converted the measurement to % value and it worked for me.

View solution in original post

2 REPLIES 2
v-yohua-msft
Community Support
Community Support

Hi, @Syndicate_Admin 

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

 

Best Regards

Yongkang Hua

Syndicate_Admin
Administrator
Administrator

I converted the measurement to % value and it worked for me.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.