Forum Discussion

hmeltonPSL's avatar
hmeltonPSL
Helper II
4 years ago

Count with ALL function and Filter

I have a gauge visual that I would like to create a MAX value for.  The MAX should not use any of the filters on the GAUGE visual so I am using ALL function.  However I want to Filter on the ALL results by DateCreated so that the total count is only records created after a certain date.

 

This is what I am using but it is not filtering by the datecreated so I am getting totalrows in the entire table.  How can I fix this?  thanks!

 

TotalRows = COUNTX(FILTER(ALL(Requests),[DateCreated]>3/17/2017),[DateCreated])

1 Reply

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    Hello there hmeltonPSL ! Try this:

    TotalRows = COUNTX(FILTER(ALL(Requests),[DateCreated]> DATE(2017, 3, 17)),[DateCreated])

    Hope this answer solves your problem!
    If you need any additional help please @ me in your reply.
    If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
    Thanks!

    You can also check out my LinkedIn!

    Best regards,
    Gonçalo Geraldes