Count with ALL function and Filter

[hmeltonPSL]

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])

[goncalogeraldes]

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