Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Buenas Tardes, tengo el siguiente modelo de datos
Necesito mostrar en la misma matriz los movimientos (Tabla MOVIMENTI) con el valor QTA_DISP_SALDO asociado al articulo del movimiento. He creado dos medidas
Si modifico la medida
Solved! Go to Solution.
Hi @mgrisolia ,
Please try code as below to update your measure.
DISP_SALDO =
VAR _table =
SUMMARIZE (
MOVIMENTI,
MOVIMENTI[ID_MOVIMENTI],
'CALENDAR'[Date],
MOVIMENTI[ARTI],
"qta",
VAR _ARTI = [ARTI]
RETURN
CALCULATE (
[DISP_SALDO1],
FILTER (
vwDisponibileRealTime,
vwDisponibileRealTime[ARTI] = _ARTI
)
) + 0
)
RETURN
SUMX ( _table, [qta] )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @mgrisolia ,
Due to I don't know what your tables look like and what columns you choose to relate between tables, here I create a sample to have a test.
Relationship in my sample:
We can see that if we use [Date] from 'MOVIMENTI' table, the issue is reproduced.
If you use [Date] from 'CALENDAR', it works. We use [Date] from 'CALENDAR' to create the date slicer.
If this reply still couldn't help you solve your issue, please share a sample file with us.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The problem with the date is solved as you say in the file you attached, but if I add another column of interest from the movement table it adds the posible combinations as shows in the following image
I need it to show me only the movement records for the selected date and to add the QTA column of the vwDisponibileRealTime table (If the item is not found in the vwDisponibileRealTime table, indicate QTA=0)
I'm trying to add the pbix file but it won't let me, for the image, use the same file that you sent me, adding an ID field to the movement table, and add a movement with an item that is not found in the vwDisponibileRealTime table.
Thanks a lot for your help
Melissa
Hi @mgrisolia ,
Please try code as below to update your measure.
DISP_SALDO =
VAR _table =
SUMMARIZE (
MOVIMENTI,
MOVIMENTI[ID_MOVIMENTI],
'CALENDAR'[Date],
MOVIMENTI[ARTI],
"qta",
VAR _ARTI = [ARTI]
RETURN
CALCULATE (
[DISP_SALDO1],
FILTER (
vwDisponibileRealTime,
vwDisponibileRealTime[ARTI] = _ARTI
)
) + 0
)
RETURN
SUMX ( _table, [qta] )
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
219 | |
89 | |
76 | |
67 | |
60 |