Forum Discussion

JamesGordon's avatar
JamesGordon
Helper II
6 years ago
Solved

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?

 

 

  • Pragati11's avatar
    Pragati11
    6 years ago

    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!

5 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    JamesGordon 

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

    • JamesGordon's avatar
      JamesGordon
      Helper II
      6 years ago

      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"?

      • az38's avatar
        az38
        Community Champion
        6 years ago

        JamesGordon 

        Yes, I didnt notice the greatest problem 🙂

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