Data should not be filtered when a specific slicer is selected.

[vimina]

I am trying to calculate Average Incident count for each Branch, for eg: the average incident for BranchA is 4.88, but when the Employee ID & Name is selected then it will be filtered accordingly, I need to ignore that filter. The Sum of Incident should be filtered by Employee Name but Average Incident should be calculated for Branch and here Employee Name & Id should not be considered. I tried using ALL(TABLENAME) but it didnt help either. Same could be acheived by turning off the edit interaction for the slicer but I am looking for a measure to acheive this.

Attached pbix file for reference: https://drive.google.com/file/d/1Jrsv3NxAqAQ_OKtHu4PhNnyWvfPPXC4n/view?usp=share_link 

[DOLEARY85 · Accepted solution]

Hi,

try this:

AVG INCIDENT = DIVIDE(CALCULATE(SUM(INCIDENT[INCIDENT_COUNT]),REMOVEFILTERS(EMPLOYEE[EMPLOEE NAME & ID])),CALCULATE(DISTINCTCOUNT(EMPLOYEE[EMPLOYEE_ID]),REMOVEFILTERS(EMPLOYEE[EMPLOEE NAME & ID])))

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍