Forum Discussion

rod_puente's avatar
rod_puente
Helper I
11 months ago
Solved

Calculation affected by segment month

Dear All   Pls your help, I have a table in PBI Desktop, but it is not taking into account the month segment. I have applied the month of January and the table with calculate continues showing me F...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    11 months ago

    Hi,

    I am not sure how your semantic model looks like, but please try something like below whether it works.

     

    KEEPFILTERS DAX FUNCTION Microsoft Learn 

     

    Cantidad Facturada Enero =
CALCULATE (
    SUM ( 'Detalle Facturacion'[Cantidad Facturada] ),
    KEEPFILTERS ( 'Detalle Facturacion'[Mes Nombre] = "Ene" )
)

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    11 months ago

    Hi,

    Ensure that the month slicer is from the Calendar table.  Simplify your measure to

    =SUM('Detalle Facturacion'[Cantidad Facturada])

Jihwan_Kim's avatar
Jihwan_Kim
Super User
11 months ago

Hi,

I am not sure how your semantic model looks like, but please try something like below whether it works.

 

KEEPFILTERS DAX FUNCTION Microsoft Learn 

 

Cantidad Facturada Enero =
CALCULATE (
    SUM ( 'Detalle Facturacion'[Cantidad Facturada] ),
    KEEPFILTERS ( 'Detalle Facturacion'[Mes Nombre] = "Ene" )
)