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 c...
  • 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!

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)
JamesGordon's avatar
JamesGordon
Helper II
6 years ago

Thanks again,

 

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

 

 

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

 

Any further suggestions?

  • Pragati11's avatar
    Pragati11
    Super User
    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!