Help with Visualization tools

[Excel-lent-User]

I have a dataset that includes team, attendance, and period. I am trying to remove filters to work properly. I want to display specific attendance for each period and each team. Additionally, I’d like to create a column chart visualization of lifetime attendance. However, the ‘remove filters’ option doesn’t show lifetime attendance. I will attach an image of what my visual looks like when I highlight a row from my chart and I can also provide the measure that is not working properly right now: 

Count Remove Filters = CALCULATE(

    REMOVEFILTERS(Data[Period Enddate])

)

[Excel-lent-User]

The new idea for the visualization to provide context from the data table to the slicers implemented to show my original desired outcome on the visual. What I mean by this is that is there a way for me to select a team name in my detail chart and have it send context to or filter to a Team Name Slicer? I want my slicers to show the period and team name from the detail chart but I just want the team name filter to be translated to the visualization. I can provide more detail if needed as well.

[shafiz_p]

@Excel-lent-UserI think slicer would be appropriate for to visualize lifetime attendance of the team you select.

Hope this help!!

[Excel-lent-User]

@aduguid Re: Detail Chart to Visualizations - Microsoft Fabric Community Feel free to look at this forum for the most up to date power bi vosualizations and questions I have on this subject

[Excel-lent-User]

I posted a new Forum with updated information and will copy and past that link below, I appreciate your help so far and a fresh set of eyes on this new question would be much appreciated. 

[Excel-lent-User]

I will try to implement this and get back to you 

[Excel-lent-User]

What I am trying to achieve is a selection in the detailed table setting team context for the chart but not time/date context. Meaning, I want to see the lifetime attendance (no time/date context) for the team I select (team context).

[shafiz_p]

@Excel-lent-User Do you want your chart not to interact with the visuals? If this is the case, then you can stop the interaction and you will get lifetime attendance regardless of selection from chart table.

[Excel-lent-User]

I did this through edditing the interactions tab under format and still the chart only shows the highlighted period 

[aduguid]

Give this measure a try 

Lifetime Attendance = CALCULATE(
    COUNTROWS(Data),
    ALL(Data[Period])
)

[Excel-lent-User]

I tried this and the visual still shows the selected period for some reason