Active Filters Pane Issues

[Mikerossanthony]

Okay so lets say I have the following dataset: 

 

Then I create a bookmarks for a user that filters to Company A, B, and C and Filters to only show Action Required. In this example only Company B has any TXs in Action Required:

I want an "Active filters" pane so users can see which filters are set, especially when using bookmarks that were setup by other users, so I created the following Measure:

Active Filters - TX Table = 
var line_break = unichar(10) & unichar(10) return
unichar(10)
& if(not(ISFILTERED(TX[Company]))&& not(ISFILTERED(TX[Status])), "All",

IF(NOT(ISFILTERED(TX[Company])),"",
"Company:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(TX[Company] ),
TX[Company],
unichar(10) & "• ")
& line_break)

& IF(NOT(ISFILTERED(TX[Status])),"",
"Status:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(TX[Status]),
TX[Status],
unichar(10) & "• ")
& line_break)
)

However, because of the cross-filtering when using ALLSELECTED() I will be missing items from the active filters pane if they do not have any data, so in this case Company A and C are missing from the active filters pane and i want them there:

I tried using parent tables instead for the report filters, and had my active filters measure point to those tables:

Active Filters - Parent Tables =
var line_break = unichar(10) & unichar(10) return
unichar(10)
& if(not(ISFILTERED(Company[Company]))&& not(ISFILTERED('Status'[Status])), "All",

IF(NOT(ISFILTERED(Company[Company])),"",
"Company:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED(Company[Company] ),
Company[Company],
unichar(10) & "• ")
& line_break)

& IF(NOT(ISFILTERED('Status'[Status])),"",
"Status:"
& UNICHAR(10) & "• "
& CONCATENATEX(
ALLSELECTED('Status'[Status]),
'Status'[Status],
unichar(10) & "• ")
& line_break)
)

This makes the active filters pane behave as I'd like however since Report filter pane is looking at the parent table, every value is 1 which I don't think I can live with:

 

Is there anyway to achieve what I'm after, either by changing the active filters measure or somehow manipulating the behavior or report filters?

[d_gosbell]

---

@Mikerossanthony wrote:

I tried using parent tables instead for the report filters, and had my active filters measure point to those tables:

---

This is the correct way of doing things. When you have a "parent" table (also called a dimension table) you should always do your filtering using that table where ever possible.

---

This makes the active filters pane behave as I'd like however since Report filter pane is looking at the parent table, every value is 1 which I don't think I can live with:

---

These values are just meant to give some indication of the row counts in the table you are filtering. They are not meant to provide any analytical value beyond that. 

Another option instead of using the filters pane would be to setup some slicers and then set them up to synch across the other pages on the report (you can set synch'ed slicers to be visible or hidden on your other pages)