topic Re: Measure by buttoms in DAX Commands and Tips

Measure by buttoms

migueldfr — Sun, 06 Apr 2025 16:38:22 GMT

Hello

I would liekt o improve this measure in order to get when I click on "mes actual hasta hoy" the values for the current month, ignoring any master Calendar[month name] selected.

Total_Importe_Cobro_Dinamico = VAR SeleccionUsuario = SELECTEDVALUE('Seleccion_Rango_Fecha'[Opcion]) VAR MesActual = MONTH(TODAY()) VAR DiaActual = DAY(TODAY()) - 1 VAR AnioActual = YEAR(TODAY()) VAR MaxYear = MAX('MasterCalendar'[Year]) VAR MesEnContexto = MAX('MasterCalendar'[Month Number]) RETURN SWITCH( TRUE(), -- ✅ Opción 1: "Mes actual hasta hoy" SeleccionUsuario = "Mes actual hasta hoy", CALCULATE( SUM(CobrosAnx[importe_cobro]), 'MasterCalendar'[IsCurrentMonth] = 1, -- Filtrar por el mes actual 'MasterCalendar'[Day] <= DiaActual -- Limitar hasta el día actual ), -- ✅ Opción 2: "Rango de fechas" (Filtrar datos en el intervalo seleccionado) SeleccionUsuario = "Rango de fechas", CALCULATE( SUM(CobrosAnx[importe_cobro]), 'MasterCalendar'[Date] >= MIN('MasterCalendar'[Date]) && -- Fecha mínima seleccionada 'MasterCalendar'[Date] <= MAX('MasterCalendar'[Date]), -- Fecha máxima seleccionada -- Aseguramos que la fecha de cualquier año seleccionado sea incluida 'MasterCalendar'[Year] >= YEAR(MIN('MasterCalendar'[Date])) && 'MasterCalendar'[Year] <= YEAR(MAX('MasterCalendar'[Date])) ), -- ✅ Opción 3: "Por Meses" (mostrar todo o limitar si es el mes actual) SeleccionUsuario = "Por Meses", CALCULATE( SUM(CobrosAnx[importe_cobro]), 'MasterCalendar'[Month Number] = MesEnContexto, -- Mes en contexto IF( MesEnContexto = MesActual, -- Si es el mes actual 'MasterCalendar'[Day] <= DiaActual, -- Limitar hasta el día actual TRUE() -- Si es otro mes, mostrar todo ) ) )

When I select a month name, the measure ofr "Mes actual hasta hoy " is showing up nothing, but I would like to keep static that filter in order to always get something for the user.

Thanks

Re: Measure by buttoms

Sahir_Maharaj — Sun, 06 Apr 2025 16:51:40 GMT

Hello migueldfr,

Can you please try this approach:

Total_Importe_Cobro_Dinamico = VAR SeleccionUsuario = SELECTEDVALUE('Seleccion_Rango_Fecha'[Opcion]) VAR MesActual = MONTH(TODAY()) VAR DiaActual = DAY(TODAY()) - 1 VAR AnioActual = YEAR(TODAY()) VAR MaxYear = MAX('MasterCalendar'[Year]) VAR MesEnContexto = MAX('MasterCalendar'[Month Number]) RETURN SWITCH( TRUE(), -- Opción 1 SeleccionUsuario = "Mes actual hasta hoy", CALCULATE( SUM(CobrosAnx[importe_cobro]), REMOVEFILTERS('MasterCalendar'[Month Name]), -- Remove any filter on the month 'MasterCalendar'[IsCurrentMonth] = 1, -- Filter by current month 'MasterCalendar'[Day] <= DiaActual -- Limit to the current day ), -- Opción 2 SeleccionUsuario = "Rango de fechas", CALCULATE( SUM(CobrosAnx[importe_cobro]), 'MasterCalendar'[Date] >= MIN('MasterCalendar'[Date]) && -- Min selected date 'MasterCalendar'[Date] <= MAX('MasterCalendar'[Date]), -- Max selected date 'MasterCalendar'[Year] >= YEAR(MIN('MasterCalendar'[Date])) && 'MasterCalendar'[Year] <= YEAR(MAX('MasterCalendar'[Date])) ), -- Opción 3 SeleccionUsuario = "Por Meses", CALCULATE( SUM(CobrosAnx[importe_cobro]), 'MasterCalendar'[Month Number] = MesEnContexto, -- Month in context IF( MesEnContexto = MesActual, -- If it's the current month 'MasterCalendar'[Day] <= DiaActual, -- Limit to current day TRUE() -- Show all if it's another month ) ) )

Hope this helps!

Re: Measure by buttoms

migueldfr — Sun, 06 Apr 2025 17:36:48 GMT

Hello

    CALCULATE(
        SUM(CobrosAnx[importe_cobro]),
        REMOVEFILTERS('MasterCalendar'[Month Name]), -- Remove any filter on the month
        'MasterCalendar'[IsCurrentMonth] = 1,  -- Filter by current month
        'MasterCalendar'[Day] <= DiaActual    -- Limit to the current day
    ),

This measure does not work as mentioned, when I select march in this case does not show up anything

I want to keep the filter ofr this month static

Thanks

Re: Measure by buttoms

tamerj1 — Sun, 06 Apr 2025 21:17:19 GMT

Hi migueldfr

You need to keep in mind that the month name column is most probably sorted by the month number column, therefore you need to remove the filter from that column as well. In fact you can just remove the filter completely from the calendar table as follows

CALCULATE (
        SUM ( CobrosAnx[importe_cobro] ),
        ALL ( 'MasterCalendar' ),
        'MasterCalendar'[IsCurrentMonth] = 1,
        'MasterCalendar'[Day] <= DiaActual
)

Re: Measure by buttoms

migueldfr — Sun, 06 Apr 2025 22:37:05 GMT

Hello

It is doing a weird action

and this is keeping for all the visualitation.

Thanks

Re: Measure by buttoms

v-sathmakuri — Mon, 07 Apr 2025 14:34:06 GMT

Hi migueldfr ,

Thank you for reaching out to Microsoft Fabric Community.

I have created a sample dataset based on your requirements and developed a measure to address the issue. Below measure ensure the values are displayed for the current month, regardless of any other filters applied.

Also attached the pbix file for your reference.

Measure:

Total_Importe_Cobro_Dinamico =

VAR SeleccionUsuario = SELECTEDVALUE(Seleccion_Rango_Fecha[Column1])

VAR TodayDate = TODAY()

VAR FirstDayOfCurrentMonth = DATE(YEAR(TodayDate), MONTH(TodayDate), 1)

VAR Yesterday = TodayDate - 1

RETURN

SWITCH(

TRUE(),

SeleccionUsuario = "Mes actual hasta hoy",

CALCULATE(

SUM(CobrosAnx[importe_cobro]),

FILTER(

ALL('MasterCalendar'),

'MasterCalendar'[Date] >= FirstDayOfCurrentMonth &&

'MasterCalendar'[Date] <= Yesterday

)

BLANK()

)

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks & Regards,

Rekha,

Customer Support Team!!

Re: Measure by buttoms

migueldfr — Wed, 09 Apr 2025 08:29:08 GMT

Thanks for response.

I am asking what about the others options, what if I select "por meses", this does not show up on the measure

Thank you

Re: Measure by buttoms

v-sathmakuri — Wed, 09 Apr 2025 13:40:10 GMT

Hi migueldfr ,

Thank you for reaching out to Microsoft Fabric Community.

Since your requirement is to fetch values for the current month while ignoring any selection from the master Calendar[Month Name] when 'mes actual hasta hoy' is clicked, the measure below will return the same results. It returns current month values while ignoring the Calendar[Month Name] filter for 'mes actual hasta hoy' and behaves the same as your original measure when other values are selected.

Total_Importe_Cobro_Dinamico =

VAR SeleccionUsuario = SELECTEDVALUE(Seleccion_Rango_Fecha[Column1])

VAR TodayDate = TODAY()

VAR FirstDayOfCurrentMonth = DATE(YEAR(TodayDate), MONTH(TodayDate), 1)

VAR Yesterday = TodayDate - 1

VAR MesEnContexto = MAX('MasterCalendar'[Month Number])

VAR DiaActual = DAY(TODAY()) - 1

VAR MesActual = MONTH(TODAY())

RETURN

SWITCH(

TRUE(),

SeleccionUsuario = "Mes actual hasta hoy",

CALCULATE(

SUM(CobrosAnx[importe_cobro]),

FILTER(

ALL('MasterCalendar'),

'MasterCalendar'[Date] >= FirstDayOfCurrentMonth &&

'MasterCalendar'[Date] <= Yesterday

)

SeleccionUsuario = "Rango de fechas",

CALCULATE(

SUM(CobrosAnx[importe_cobro]),

'MasterCalendar'[Date] >= MIN('MasterCalendar'[Date]) && -- Fecha mínima seleccionada

'MasterCalendar'[Date] <= MAX('MasterCalendar'[Date]), -- Fecha máxima seleccionada

-- Aseguramos que la fecha de cualquier año seleccionado sea incluida

'MasterCalendar'[Year] >= YEAR(MIN('MasterCalendar'[Date])) &&

'MasterCalendar'[Year] <= YEAR(MAX('MasterCalendar'[Date]))

-- Opción 3: "Por Meses" (mostrar todo o limitar si es el mes actual)

SeleccionUsuario = "Por Meses",

CALCULATE(

SUM(CobrosAnx[importe_cobro]),

'MasterCalendar'[Month Number] = MesEnContexto, -- Mes en contexto

IF(

MesEnContexto = MesActual, -- Si es el mes actual

'MasterCalendar'[Day] <= DiaActual, -- Limitar hasta el día actual

TRUE() -- Si es otro mes, mostrar todo

)

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks & Regards,

Rekha,

CustomerSupportTeam.

Re: Measure by buttoms

migueldfr — Wed, 09 Apr 2025 17:23:57 GMT

is true that I want to ingoring any selection that has been selected on month name box

But in parallel I want it show me up the right value for the actual month

and now is not working as I expected

Thanks

Re: Measure by buttoms

tamerj1 — Wed, 09 Apr 2025 20:55:15 GMT

migueldfr

What are you expecting to see in this chart?

Re: Measure by buttoms

v-sathmakuri — Thu, 10 Apr 2025 13:09:59 GMT

Hi migueldfr ,

Could you please explain your follow up query in details to provide better solution.

Thanks & Regards,

Rekha.

Re: Measure by buttoms

v-sathmakuri — Tue, 15 Apr 2025 14:17:48 GMT

Hi migueldfr ,

May i know if the issue is resolved, if not please share more details on you issue to provide beter solution.

If your issue is resolved, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you !!

Re: Measure by buttoms

migueldfr — Wed, 16 Apr 2025 07:55:49 GMT

not the same amount, but the diferent values in order to compare both

Re: Measure by buttoms

v-sathmakuri — Wed, 16 Apr 2025 15:58:26 GMT

Hi migueldfr ,

Please confirm if this is the preferred way to display the different amounts on the chart. I have attached the PBIX file for your reference. Please let us know if any further details needed.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thank you!!

Re: Measure by buttoms

v-sathmakuri — Mon, 21 Apr 2025 12:14:02 GMT

Hi migueldfr ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you!!

Re: Measure by buttoms

v-sathmakuri — Fri, 25 Apr 2025 06:57:56 GMT

Hi migueldfr ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!