DAX Filter Assistance

[Anonymous]

So I am looking to create a column using a DAX Expression that identifies whether an assignment was past due or not. The column is called "Due in Canvas". And I am looking to use a column that will display whether or not it is later than today's date. 

So on the raw file, it is using a COUNTIF function to determine how many assignments were submitted later on a due date:

              =COUNTIF(Assignments!):),"<"&TODAY())

I know you cannot do a COUNTIF in PowerBI. I was curious to see if there is any other options I may have to achieve this count?

[SpartaBI]

@Anonymous ye sure, quite easy, just not sure exactly what you need. Can you share a sample file or a copy paste table from excel with the desired result?

[Anonymous]

@SpartaBI 

The ask is to create 2 visuals very similar to this. The report have has the total. I got the Total Assignments fine (easiest one to do). And then I was able to use a SWITCH (TRUE() to determione the multiple statuses of an assignment as Received or Not Received. 

[Anonymous · Accepted solution]

I think I got it! But I could be wrong. So what I did was create a another column called past due. And did an IF statement to determine if the date is < TODAY && if the Deliverable was " Not Received"

[SpartaBI]

@Anonymous Ye, look at what I just wrote in the previous message

[SpartaBI]

@Anonymous still don't have enough info but will take a guess:
MEASURE = CALCULATE( COUNTROWS ( 'Table' ), 'Table' [Due in Canvas] < TODAY() )

Showcase Report – Contoso By SpartaBI