cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rodlauro Frequent Visitor
Frequent Visitor

calendar problem ignoring month on measure

Hi,
I have a simple matrix with a sum and  the MONTH- YEAR column.
What I need is that the measure of the sum ignore the selected month filter, but not ignore the year filter.

So, If yo filter the year 2018 and the month MARCH , yo can see the columns 2018 - JANUARY, 2018 FEBREARY,  2018 MARCH
The actual month and the previus from the beggining of the year
I can not ignore the month using  ALL in my calendar table like this
SumFacturado = CALCULATE( Sum(money); ALL(calendario )

nether this

SumFacturado = CALCULATE( Sum(money); ALLEXCEPT(calendario; calendario[Month] )

please help!
2 REPLIES 2
Community Support Team
Community Support Team

Re: calendar problem ignoring month on measure

@rodlauro ,

 

You may add a separate table for Slicer, apply virtual relationship in DAX measure and then take advantage of Visual level filters.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rodlauro Frequent Visitor
Frequent Visitor

Re: calendar problem ignoring month on measure

Hi, Thanks for reply!!
I am sorry but I do not know how to add a separeta table for slicer and apply as a virtual relationship.
I have y tables: SEllS and CALENDAR.  In Calendar I have Year & Month
YEAR is working ok, but If I ignore the MONTH I see all the months of the year.

Thanks in advance!