Removing a Slicer from a measure used ina table that is sliced..?

[ballist1x]

Hi, i have a table that i created that shows the volume of something and some percentages

ultimately i am using a date filter to select the time period over a 13 month period to filter all of the data in the table.

i then apply a Month filter (separate column within the data) to get the table to show data for only that month (this year and last year).

I am trying to calculate the 13 month total of volume, however, as i have selected the Month filter whenever i use this calculation it is incorrect on the basis that it only returns the value on the Month that i have selected.

i want the measure to Sum the total volume over that 13 month period i selected via the date slicer, but ignore the Month slicer 

and i have treid various versions of this:

CALCULATE([Total No DR], ALLEXCEPT('Deal Registrations', 'DR'[Date Logged], 'DR'[Vendor Name]), ALL('DR'[Month Logged]))

Total No DR = CALCULATE(COUNT('DR'[Index]))

[v-frfei-msft · Accepted solution]

Hi @ballist1x ,

One sample for your reference, please check the following steps as below.

1. To create a date table and create inactive relationship between the fact table as below.

date = CALENDARAUTO()

2. To create a measure as below to work the excepted result out.

sumif = 
IF (
    ISFILTERED ( 'date'[date] ),
    CALCULATE (
        SUM ( 'Table'[sale] ),
        FILTER ( ALL ( 'Table' ), 'Table'[date] IN VALUES ( 'date'[Date] ) )
    ),
    CALCULATE (
        SUM ( 'Table'[sale] ),
        USERELATIONSHIP ( 'date'[Date], 'Table'[date] )
    )
)