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. 

     

Shravan133's avatar
Shravan133
Super User
6 months ago

try this: 

 

Widgets at Status 23 :=
CALCULATE (
DISTINCTCOUNT ( WidgetHistory[WidgetID] ),
WidgetHistory[CurrentStatusID] = 23,
REMOVEFILTERS ( WidgetHistory[ModifiedBy] )
)

Why the table visual shows 398 but the card shows 396

  • Table visual shows distinct widgets

  • Card is counting filtered history rows

  • Two widgets disappear because their latest row was modified by someone else



  • Jdogg's avatar
    Jdogg
    New Member
    6 months ago

    DISTINCTCOUNT gives a value of 1. COUNT gives the value of 396