cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
nmeliasp Frequent Visitor
Frequent Visitor

Calculate Number of rows with non blank dates

Hello I have a table similar to the table below. I am trying to create a measure that calculates the rows that have completions dates for the West Area. 

 

ItemAreaCompletion Date
XXWest5/21/2019
YYWest 
ZZSouth5/22/2019

 

I would like this measure to return 1 in this simple example

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Calculate Number of rows with non blank dates

@nmeliasp ,

 

Do you want to calculate the row number of West Area which has Completion Date? You can also create a measure and drag the measure to the card visual:

Result = COUNTX(FILTER(Table1, Table1[Completion Date] <> BLANK() && Table1[Area] = "West"), Table1[Item])

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Super User
Super User

Re: Calculate Number of rows with non blank dates

Hi,

Drag Area to the Row labels and write this measure

=COUNT(Data[Completion Date])

Hope this helps.

Community Support Team
Community Support Team

Re: Calculate Number of rows with non blank dates

@nmeliasp ,

 

Do you want to calculate the row number of West Area which has Completion Date? You can also create a measure and drag the measure to the card visual:

Result = COUNTX(FILTER(Table1, Table1[Completion Date] <> BLANK() && Table1[Area] = "West"), Table1[Item])

Capture.PNG 

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.