Don't Filter Measure

[Anonymous]

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 filter, how can the measures that are static be the same

[v-kelly-msft]

Hi @Anonymous ,

You can use function all or allselected to make the measure not be filtered.

Such as calculate(sum(table[Value]),all(Date))   OR  calculate(sum(table[Value]),allselected('table'))

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

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-tr...

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