Ignore Slicers from different tables

Question

Hi Team,&nbsp;I am new to Power BI and trying to get a solution to one of the issue. I have three filters&nbsp; Status, Type and Date&nbsp; coming from three different tables. The user has to make the selection from the three filters&nbsp; and depending on the selection will get corresponding rows.&nbsp;There is an other filter Ticket ID where the user enters the Incident number to get the corresponding Ticket details from the Remedy Tickets Detail Table .For Example if the user selects the status Active all the corresponding Tickets will show up and will be able to enter the Ticket IDs&nbsp; which are Active and get Status.&nbsp;Now the requirement is user wants to enter any Ticket ID and get the details&nbsp; regardles&nbsp; of the Status Selection, Type and Date. For Example&nbsp; if the Status Active is selected and user enters a Ticket ID which has Closed Status and should be&nbsp; be able to get all the details.I Tried All, All Except but condition is not working..&nbsp;CALCULATE(DISTINCT(DMO_REMEDY_TICKETS[Ticket_ID]), ALL('Ticket Status_2'))&nbsp;Is All or All Selected can ignore the filters coming from different tables?&nbsp;Any Suggestions Appreciated.&nbsp;Thankyou

dax · Answer

Hi jthota,
I don't know, how you design your report? You could refer to my sample, which will ignore status slicer in measure 5. By the way, if possible, could you please inform me more detailed information (such as your sample data and expected output). Then I will help you more correctly.
Please do mask sensitive data before uploading.
Thanks for your understanding and support.Best Regards,Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
&nbsp;

anonymous · Answer

Hi,Zoe,Thankyou for the response.&nbsp;I have three filters&nbsp; as below which are mandatory and has to be entered and depending on the selection will get the data.The user can select the other filters&nbsp; like Ticket ID,&nbsp; Summary, Impact, Owner, Urgency, Priority, CategoryStatus&nbsp; Active&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Closed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;Incident&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dec&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Opened&nbsp;&nbsp; &nbsp;&nbsp; Service Request&nbsp;Summary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Owner&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Assigned Queue&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Opened Date&nbsp;&nbsp;&nbsp;&nbsp; Urgency&nbsp;&nbsp;Project Design, Build and Functional Test&nbsp;&nbsp; Benitez, Christopher&nbsp;&nbsp;&nbsp;Data Center Operations&nbsp; Anthony Chan&nbsp;&nbsp; 12/19/2018&nbsp;&nbsp;&nbsp;&nbsp; LowType&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Ticket ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Status&nbsp;&nbsp;&nbsp;Incident&nbsp;&nbsp;&nbsp; 00658182&nbsp;&nbsp;&nbsp;&nbsp; Active&nbsp;The Ticket Details are showing for Status Active.&nbsp;The current requirement is user wants to enter any Ticket ID and wants to get the status even the Status selection is Active and user enters a Ticket ID which is not Active and wants to see data. The above three filters like Status, Type and Date to be ignored and wants to get data for any Ticket ID.&nbsp;Thanks,Jyothi&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Ignore Slicers from different tables

2 Replies

Related content

Ignore Slicer in measure

Ignoring Date Slicer with measure

Power BI – YoY Measure Ignoring Product Filter but Respecting Slicers

Dax to Ignore Specific Slicer

DAX Measure ignore filter/slicer selection