22.12 How All Filters Combine
Slicers, Filters pane filters (all levels), cross-filtering, drill-through and RLS are combined with AND logic into the filter context (गाळणी संदर्भ – सध्या कोणते फिल्टर लागू आहेत) of every measure (Module 13.3). CALCULATE with ALL/REMOVEFILTERS can ignore some of them inside a measure. RLS can never be ignored.
Practice task
On the Executive page: add Platform (tile), City (dropdown, multi-select), Order Date (between) and Category (hierarchy with Product) slicers. Sync Platform and Order Date to all pages (visible only on Executive). Add a hidden page filter excluding test stores and a locked filter State = Maharashtra. Set the "All platforms" card to ignore the Platform slicer, and add a Top 5 products filter on a bar chart.
Samjla ka? Sagle filters AND ne combine hotat. Nasel tar ha section punha ekda vacha.
Ravindra Bagale's Tip
Friends, many students forget that all filters combine with AND: report filter, page filter, visual filter, slicers, cross-filters and RLS. When a visual shows blank, check each layer one by one, starting with the Filters pane and then the slicers. This matters for both exams and interviews.
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students विसरतात की सगळे filters AND ने एकत्र येतात: report filter, page filter, visual filter, slicers, cross-filters आणि RLS. Visual blank दिसला तर प्रत्येक थर एक-एक करून तपासा, आधी Filters pane आणि मग slicers. हे exam आणि interview दोन्हीसाठी important आहे.
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students भूल जाते हैं कि सारे filters AND से मिलते हैं: report filter, page filter, visual filter, slicers, cross-filters और RLS. Visual blank दिखे तो हर परत एक-एक करके check करो, पहले Filters pane और फिर slicers. यह exam और interview दोनों के लिए ज़रूरी है.
Thodkyaat sangaycha tar (quick recap)
Sagle filters AND ne combine hotat; slicer sync karayla visru naka; aani visual blank disla tar Filters pane layer by layer check kara. Samjla ka? Aata pudhe jaauya design principles kade.