Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi,
try this:
Hi,
try this: