cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Filter Error

Hi,

 

I am trying to filter out certain records to create a Card that will illustrate the oldest "Ord date" and displayy age in days.

 

I would like to filter column "INV" with any records that contain number 37 so i can see the corresponding "Ord Date" - below is a screenshot of my DAX with the error - am i doing something wrong?

 

Power Bi ques 2.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: Filter Error

Hi @JamesGordon ,

 

If you check your DAX expression correctly, it is missing a closing bracket for COUNTROWS (in red below). Copy hte DAX below and use it:

 

Warranty = CALCULATE(COUNTROWS (Sheet) , Sheet[Inv] = 37)

 

Thanks,

Pragati

 

If this works, Please mark this as a solution!



Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

View solution in original post

5 REPLIES 5
Highlighted
Super User II
Super User II

Re: Filter Error

@JamesGordon 

it looks like you creating a measure you should use like SELECTEDVALUE(Sheet[Inv])=37


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Highlighted
Helper II
Helper II

Re: Filter Error

Hi Az28,

 

Thank you for the help - unfortunately i get the following error in the Card?

I am looking to filter out all rows with the number 37 then display the oldest date - do i need to have two filter commands, i.e one to filter out the rows with "37" and another filter commaned to find the oldest date in column "Ord date"?

Power Bi ques 3.jpg

Highlighted
Super User II
Super User II

Re: Filter Error

@JamesGordon 

Yes, I didnt notice the greatest problem 🙂

Number of Warranty = 
CALCULATE(COUNTROWS(Sheet), Sheet[Inv]=37)

do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

Highlighted
Helper II
Helper II

Re: Filter Error

Thanks again,

 

Unfortunately when i try to search for the Column in the sheet it does not appear in the list? As per below -

 

Power Bi ques 4.jpg

 

if i manually type the command in then i get the following error?

Power Bi ques 5.jpg

 

Any further suggestions?

Highlighted
Community Champion
Community Champion

Re: Filter Error

Hi @JamesGordon ,

 

If you check your DAX expression correctly, it is missing a closing bracket for COUNTROWS (in red below). Copy hte DAX below and use it:

 

Warranty = CALCULATE(COUNTROWS (Sheet) , Sheet[Inv] = 37)

 

Thanks,

Pragati

 

If this works, Please mark this as a solution!



Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

View solution in original post

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

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