Forum Discussion

Jdogg's avatar
Jdogg
New Member
6 months ago
Solved

Self-Filtering

I have a table from a SQL server. When I want to see specific data via a visual based on a name I select, it self-filters certain things. My table is called WidgetHistory. The column I want to pull d...
Need Help
  • pcoley's avatar
    pcoley
    6 months ago

    Jdogg the report is working as expected. by default, if you select a value in a visualization, that value will filter other visualizations in the report. 
    you can change this adding an ALL or REMOVE in the CALCULATE filters:

    CALCULATE (

    COUNTROWS(WidgetHistory), ALL(WidgetHistory), WidgetHistory[CurrentStatusID] = 23)

    Or changing the interaction between visualizations:

     i hope this help, if so please mark as a solution. kudos are welcome. 

     

pcoley's avatar
pcoley
Super User
6 months ago

Jdogg the report is working as expected. by default, if you select a value in a visualization, that value will filter other visualizations in the report. 
you can change this adding an ALL or REMOVE in the CALCULATE filters:

CALCULATE (

COUNTROWS(WidgetHistory), ALL(WidgetHistory), WidgetHistory[CurrentStatusID] = 23)

Or changing the interaction between visualizations:

 i hope this help, if so please mark as a solution. kudos are welcome.