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

Don'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.

Reply
mgrisolia
Regular Visitor

Ignore Date filter

Buenas Tardes, tengo el siguiente modelo de datos

mgrisolia_0-1737463381297.png

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

DISP_SALDO1 = SUM(vwDisponibileRealTime[QTA_DISP_SALDO])
DISP_SALDO =
var _qta=SUMX(MOVIMENTI, [DISP_SALDO1])+0
RETURN
_qta
 MI problema es que cuando adiciono la medida DISP_SALDO a la matriz el filtro del calendario deja de tener efecto:
Con medida DISP_SALDO
mgrisolia_2-1737463783303.png

 

Si modifico la medida 
DISP_SALDO =
var _qta=SUMX(MOVIMENTI, [DISP_SALDO1])
RETURN
_qta
 y elimino el 0, el filtro tiempo es correcto, pero necesito que los movimientos de ese dia, sin QTA_DISP_SALDO vengan mostrados en la matriz. Es decir, necesito que todos los movimientos de ese dia vengan mostrados, sin importar si tienen o no una QTA_DISP_SALDO.

 

Espero haberme expresado de manera clara, gracias por cualquier ayuda que puedan brindarme
Melissa

 

 

 

1 ACCEPTED 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.

vrzhoumsft_0-1737623193590.png

 

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.

View solution in original post

4 REPLIES 4
mgrisolia
Regular Visitor

Hi @v-rzhou-msft , 

Thank you very much for your help, it works perfectly.

v-rzhou-msft
Community Support
Community Support

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:

vrzhoumsft_2-1737510187679.png

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.

vrzhoumsft_0-1737510087250.png

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

 

mgrisolia_1-1737534797268.png

 

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.

vrzhoumsft_0-1737623193590.png

 

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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