Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Don't Filter Measure

Hello,   I have measures that should not be filtered ie they have no date range in the table and should only change when the data is updated. Another table used has dates so we need to have a date ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Unless two tables are connected. They will not filter each other.

The ideal way is that you connect all other tables to date and use the date filter. Other than the one table you do not want.

If you want to join, you can create a measure like this to void date join

calculate(sum(table[Value]),all(Date))

Having this in another table is important so that other filters can work.

One more option to remove join is crossfilter. Refer this article, which uses it for current employees: https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin