CALCULATETABLE with 2 filters

[bkennedype]

New to Power BI and struggling a little bit with syntax.  I'm not a programmer but could easily do this with a regular SQL query.

Here is my CALCULATETABLE query - it uses a measure to filter what I need, but I need to add a second filter.

Events7Days = filter(CALCULATETABLE(ALL('pip Events')),'pip Events'[End_Date]>=DateTable[7DaysAgo])

7DayAgo is a measure that I added to my DateTable.  The rows with "0" are the rows I want to filter but I can't figure out how to add a second filter to this.

Any help would be appreciated.

Thanks

[Phil_Seamark · Accepted solution]

Hi @bkennedype

Have you tried...

Events7Days = 
    filter(
        CALCULATETABLE(
            ALL('pip Events')
            ),
            'pip Events'[End_Date]>=DateTable[7DaysAgo] && 
            'pip Events'[Draw_ID] = 0
            )

[bkennedype]

That works.....once I change the = 0 to <> 0

Events7Days = filter( CALCULATETABLE( ALL('pip Events') ), 'pip Events'[End_Date]>=DateTable[7DaysAgo] && 'pip Events'[Draw_ID] <> 0 )

Thanks for your help.  I now see how to add multi-filters

[Phil_Seamark]

Hi @bkennedype

Well done!  I wasn't sure if you wanted to keep the zeros or get rid of them. I figure you could tweak the pattern to suit. 🙂