Two dates from the same database

Hi jmatamal ,

If I understand correctly,  you would like to get the count of guides created and guides entered. But you can't get the correct count of guide entered. Can I  know how did you set your table visual in Power BI? Please try to follow the steps below to do it and check if you can get the expected result...

1. Delete the relationship between the calendar table and fact table

2.  Create a table visual: put the field [Fecha] of calendar table and the following two measures onto the table visual

Count of guides creation =
VAR _seldate =
    SELECTEDVALUE ( 'Calendario'[Fecha] )
RETURN
    CALCULATE (
        COUNT ( 'ReporteIngresoGuiasxx'[Fecha_Creacion] ),
        FILTER (
            'ReporteIngresoGuiasxx',
            'ReporteIngresoGuiasxx'[Fecha_Creacion] = _seldate
        )
    )

Count of guides entered =
VAR _seldate =
    SELECTEDVALUE ( 'Calendario'[Fecha] )
RETURN
    CALCULATE (
        COUNT ( 'ReporteIngresoGuiasxx'[Fecha_Ingreso] ),
        FILTER (
            'ReporteIngresoGuiasxx',
            'ReporteIngresoGuiasxx'[Fecha_Ingreso] = _seldate
        )
    )

Best Regards