Forum Discussion

lasthero's avatar
lasthero
Frequent Visitor
9 years ago

Removing Page level filter for just 1 visualization

Is there anyway to remove the page level filter for just 1 visualization?   For example I have a card visualization that displays the count for November of data i am working with.  The whole page h...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi lasthero,

 

You can try measurements on these visuals that cancel the filtering done by page or report-level filters, like so:

 

ID_all = CALCULATE(DISTINCTCOUNTNOBLANK(Table[ID]),ALL(page_filter),ALL(report_filter))

 

So all the other visuals can use the Table[ID] column, for those that you want to remove filtering, you can use ID_all.

 

Please mark as solved if you find it useful.

 

Best,

 

Leo

alienlin's avatar
alienlin
Frequent Visitor
5 years ago

Thanks, this code works! 🙂 🙂


ID_all = CALCULATE(DISTINCTCOUNTNOBLANK(Table[ID]),ALL(page_filter),ALL(report_filter))