Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
Hi @bkennedype
Have you tried...
Events7Days = filter( CALCULATETABLE( ALL('pip Events') ), 'pip Events'[End_Date]>=DateTable[7DaysAgo] && 'pip Events'[Draw_ID] = 0 )
Hi @bkennedype
Have you tried...
Events7Days = filter( CALCULATETABLE( ALL('pip Events') ), 'pip Events'[End_Date]>=DateTable[7DaysAgo] && 'pip Events'[Draw_ID] = 0 )
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
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. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |