Help getting a slicer/filter ignored in a measure

[Anonymous]

Hi

DPL Revenue = CALCULATE(sum('DPLImportPBI'[Forecast Revenue]),filter('DPLImportPBI',DPLImportPBI[IsLastestSubmissionValue]="Yes"))

Fo the above measure I want it to ignore a slicer on the page of the report. The Slicer is for a column called "Submission"

I have tried the following and it does not work

DPL Revenue = CALCULATE(sum('DPLImportPBI'[Forecast Revenue]),filter('DPLImportPBI',DPLImportPBI[IsLastestSubmissionValue]="Yes"),all('DPLImportPBI'[Submission]))

The above attempt does not work. The measure still changes with the slicer

[Anonymous]

Please note below also does not work.... the measure still changes it result when making slicer selections for the Submission column

DPL Revenue v2 = CALCULATE(sum('DPLImportPBI (2)'[Forecast Revenue]),filter('DPLImportPBI (2)','DPLImportPBI (2)'[IsLastestSubmissionValue]="Yes"),ALLEXCEPT('DPLImportPBI (2)','DPLImportPBI (2)'[Submission]))

[v-ljerr-msft]

Hi @Anonymous,

Could you try the formula below to see if it works in your scenario? 

DPL Revenue =
CALCULATE (
    SUM ( 'DPLImportPBI'[Forecast Revenue] ),
    FILTER (
        ALL ( 'DPLImportPBI'[Submission] ),
        DPLImportPBI[IsLastestSubmissionValue] = "Yes"
    )
)

Regards

[Anonymous]

That errors out from where I highlighte in red.... Note IsLastestSubmissionvalue is a column with yes/no data its not a measure.

DPL Revenue =
CALCULATE (
    SUM ( 'DPLImportPBI'[Forecast Revenue] ),
    FILTER (
        ALL ( 'DPLImportPBI'[Submission] ),
        DPLImportPBI[IsLastestSubmissionValue] = "Yes"

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

My mistake. 

Based on my test, the formula below should work in your scenario. 

DPL Revenue =
CALCULATE (
    SUM ( 'DPLImportPBI'[Forecast Revenue] ),
    ALL ( 'DPLImportPBI'[Submission] ),
    DPLImportPBI[IsLastestSubmissionValue] = "Yes"
)

Regards

[Anonymous]

Looks like that is working.... thanks

I have a few other measure where I need to replicate this solution

thanks again