Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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:
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
85 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |