cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Re: Make measure ignore specific filter

Would you please let me know how did you resolve this I am facing similar issue. TIA

Highlighted
Solution Sage
Solution Sage

Re: Make measure ignore specific filter

This is not really an issue. It is clearly explained in this article from Alberto. It is happening because of Auto Exist feature in DAX.

Besides, creating a seperate dimension table is not really a workaround, but rather a best practice. A Star Schema is always considered best when working with Power BI Datamodel. This is what makes it more powerful!

 

 

View solution in original post

Highlighted
Advocate III
Advocate III

Re: Make measure ignore specific filter

Thank you! Finally someone cares to understand the problem thoroughly and not just throws out a guess!
Highlighted
Regular Visitor

Re: Make measure ignore specific filter

I have created a different distinct values table for Month+Year, and used ALL( Table2[Month+Year]) in CALCULATE function. Still doesn't work for me! any other solution I can try out? 

Highlighted
Frequent Visitor

Re: Make measure ignore specific filter

@Greg_Deckler 

Hi Greg,

 

My measure is giving wrong column sub total but correct row sub total.

 

My Actual Measure in the report:

 

Measure =

VAR Y=
CALCULATE(SUMX(VALUES('CurrentTimeEntry Details'),[ActualHours]),ALLSELECTED('Staff Details'[Employee Name])]))

VAR X = CALCULATE(SUM ('CurrentTimeEntry Details'[ActualHours]))

Return x/Y

Output I am getting:
 
EmployeeProject1Project2Total
A0.300.3
B0.210.190.25(NOT CORRECT)
C00.30.3
Total0.510.491


It is coming wrong as the measure is behaving at the backend like below ie ( Filtering across the project)
 
Measure = 
VAR Y=
CALCULATE(SUMX(VALUES('CurrentTimeEntry Details'),[ActualHours]),ALLSELECTED('Staff Details'[Employee Name]),ALLSELECTED('Project Details'[Complete Project Detail]))  <--- Filtering

VAR X = CALCULATE(SUM ('CurrentTimeEntry Details'[ActualHours]))

Return x/Y

Can you please suggest the solution as I am unable to avoid filtering and fix this
Highlighted
Resolver I
Resolver I

Re: Make measure ignore specific filter

Can you try calculate ( [measure], allexcept ( .......the one item you're trying to have work as a filter....)?

 

And if you need to, you could go to the table that your filtering against and add custom columns to allow easier filters

Highlighted
New Member

Re: Make measure ignore specific filter

Thank you @kxtayl18!! Solved my problem perfectly!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors