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 )
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!