Forum Discussion
migueldfr
Helper IV
Helper IVMeasure by buttoms
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_Impo...
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!!
tamerj1
Community Champion
Community ChampionHi 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
)