Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
MiaSunny
New Member

Disable a filter while tables are related

Hi, 

 

I have some tables 2 fact tables: one from timesheet for hours used, the other one from SQL to get the count of tasks. 

the usernames and report names are different in the 2 platforms.

I am able to build a measure like: 

AverageTimeUsed = Divide( sum(timesheet[hours]), sum(SQL[CountofTasks])) to get the average processing time for each task. 

And I d like to have another measure shows the team average processing time. 

In a page I will have a table compares the processing time and average processing time, and add 2 slicers on username and date. 

when all the team members are  selected the 2 average time should be the same; and when some team members are selected, show the comparision between these people and the team average(it should not be changed by the username filter, but should be changed according to the date slicer) 

 

I tried

calculate(sum(timesheet[hours]),

ALL( timesheet[username]))  and

calculate ( sum(timesheet[hours]),

removefilters(timesheet[username]))

both are not working. 

And i tried to put all the columns related: 

calculate( sum(timesheet[hours]),

removefilters(timesheet[username]),

removefilters(sql[username]),

removefilters(usernameMappingTable[username])) 

or use ALL instead of the Removefilters function, the data are still changing with the slicer. 

 

Thank you for reading and all suggetions are appreciated! 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

use CROSSFILTER(x,y,NONE)

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

use CROSSFILTER(x,y,NONE)

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.