ignore the value selected in slicer so that the bar graph will show all..measure..

[Raj007]

Hi All, Thanks for your time. I have this scenario with the data from 2 tables 

1)Table1: this includes the dataset of ticket incidents and this dataset is joined to kind of mapping table based on event_code

    1 event code can have multiple ticket incidents

2).Table2: this is kind of mapping table that is joined with the Table1 and this includes some derived fields current or previous1 or previous2 etc

I have the slicer coming from Table2 as this field helps  me to filter specific - but i do not want the selection to apply for the bar graph only (i still need this applied to KPIs using card but not for the bar graph)

I have tried sevaral options using ALL, REMOVEFILTERS, ALLSELECTED in my measure but nothing is working..

I use 1 field to slicer and use another field in bar graph.... when the value in slicer is selected i do not want the bar graph to get impact -- meaning it should everything from my field that i used in my bar graph

my measure = vTotalTickets=calculate(distinctcountnoblank(TicketIncidnetNumber) )

[Raj007]

Hi Amit, as always thanks a lot. edit interactions and turn off - but i want to understand why the

REMOVEFILTERS(),ALL(), ALLSELECTED() are not working..

i have the filter field in 1 table

measure is the count of a column which is in another table

[amitchandak]

@Raj007 , if you do want to apply to bar two then use edit interaction.

How Interactions Work- Split Page using interactions to compare - https://youtu.be/GIfRKzhMaR4

You might need an independent table

Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

[Raj007]

Hi Amit,

i have this solution and i think this should help me -- in such scenario where i do not want to use the

"edit interactions" and independent table - this is like 3rd option but i need expertise

1).I want to get the column that i used for slicer from the mapping table - one side

2) into my many side table and use the removefilters(use the column that is pulled)

    and count the distinct tickets from the many side table - this is where i use the measure to count

what do you think of this approach