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. 

     

krishnakanth240's avatar
krishnakanth240
Super User
6 months ago

Hi Jdogg 

 

Can you try this measure

Widgets Status 23 =

CALCULATE (COUNTROWS (WidgetHistory),

WidgetHistory[CurrentStatusID] = 23,

REMOVEFILTERS(WidgetHistory[ModifiedBy]))

 

Jdogg's avatar
Jdogg
New Member
6 months ago

Doesn't change anything, but thank you