eliminate the need of adding a filtering column to a table visual?

[jjkennyan0]

Hello! What to i need to do in order to eliminate the need of adding a filtering column to a table visual? Background: I have a table with records of sales for a bunch of stores. These stores are categorized by concept. I've set up a dashboard to benchmark a selected stores sales with the average sales per item of the corresponding concept group. I've written some dax which I think is working correctly, but only when add the concept name column to the table. When omitting the concept name from the visual it just returns the global average sales of all stores per item, regardless of concept.

I have used the following Dax:

*Calculate(Averagex(
(Summarize(Store,StoreConcept,StoreName,[Sum_Sales]),
Allexcept(Store,StoreConcept)
)
*

which seems to work fine as long as the concept name is added to the visual. Can I hide this column in the visual, or is there something need to do with my DAX code? Highly appreciative of any help or nudge in the right direction, many thanks!

[ray_ux]

@jjkennyan0  You can try adding concept name (or id) as a visual level filter and use "not blank" 

[jjkennyan0]

Thanks for the quick reponse.  Is there a way to do it without having show it on the filter pane?

[ray_ux · Accepted solution]

@jjkennyan0  You can hide a column with color settings under Conditional Formatting. Choose to affect both values and column names. Normally I used this method for overcoming the severe limitations of column sorting. I created some fixed measures with. ie. a value of one, then used it in some conditional formatting rule, etc

[jjkennyan0]

Wow, i didn't know that was possible. Cheers! 😊