Date comparison in power bi dax

Question

I want to create a code which compares the date in Power Bi DAX and I had a problem with the code which I created and it was not working 

Total Open Issues = 
--------------------
--basic info
VAR SELECTEDDATE =
    DATEVALUE(SELECTEDVALUE(Calender[FullDateAlternateKey].[Date]))
--------------------
--FIND the relvent data
VAR rlvttable =
    calculatetable(
    Tracker,
    Tracker[Catagory]="ISSUE",
    DATEVALUE(Tracker[ClosedDate])>SELECTEDDATE
       ||Tracker[ClosedDate]=""
    )
--------------------
--Results
Return
    countrows(rlvttable)

How can I correct this? 

Answer 1

use the following dax equation

Tracker[ClosedDate]>SELECTEDDATE
   &&Tracker[ClosedDate]=""

Want to learn more about Power BI? Check out today: Power BI course