make Second Filter Calculate PY

[Anonymous]

Hi Expert

I have the following DAX which is driving me arond the bend, how wouldyou make the second filter on the second calculate PY...

Issues lie with the DAate Filter [Dim_Date_SK]

CALCULATE(
        [Net Sales @ PY Rate BM]
        ,
        FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]),
            CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) )
         )/CALCULATE(
        [Net Sales BM PY]
        ,
         FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]),
            CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) )
         ))

[v-piga-msft · Accepted solution]

Hi @Anonymous,

Based on your description, I cannot understand your scenario well. 

However, for your formula, it seems that you have an error for syntax. You'd better remove the last ")" like below and have a try.

CALCULATE(
        [Net Sales @ PY Rate BM]
        ,
        FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]),
            CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) )
         )/CALCULATE(
        [Net Sales BM PY]
        ,
         FILTER( ALL(Profitability[DIM_POSTING_DATE_SK]),
            CONTAINS( VALUES('DateFilter'[DIM_DATE_SK]),'DateFilter'[DIM_DATE_SK], Profitability[DIM_POSTING_DATE_SK] ) )
         )

To get the solution, you'd better share your data sample and your desired output so that we could help further on it.

Best Regards,

Cherry

[Greg_Deckler]

Sample data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, you may have some luck with this method: https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

[Anonymous]

Apologies but totally lost......help please....