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. 

     

danextian's avatar
danextian
Super User
6 months ago

Hi Jdogg 

 

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

 

The formula above is internally written as 

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

 so the filter modified is applied to CurrentStatus only

 

Try 

CALCULATE (
    COUNTROWS ( WidgetHistory ),
    FILTER (
        ALL ( WidgetHistory ),
        WidgetHistory[CurrentStatusID] = 23
    )
)
  • Jdogg's avatar
    Jdogg
    New Member
    6 months ago

    That gives me all widgets (126,168) and the number doesn't change based on who i select in my drop down.