Need help counting rows in another table and populating cells with those counts

[pchilton]

I need assistance, I am new to PowerBI and especially DAX. I am trying to write a bug arrival report that includes days with 0 bugs written and days where there is a record in my source VSTS data. I was able to use PowerBI to create a report, but it did not include days where there were no bugs entered because those records did not exist in the source data. I am trying to create another table to use in my graphing.

VSTS Source Data

Below is a  Table I created with Columns: Date, Period and CreatedDate.

I want the values in CreatedDate in the DatePeriod table to equal the number of instances found in the CreatedDate column from VSTS.  Currently my code is bringing back the total number of records in the VSTS table and populates each row in the CreatedDate column regardless of bugs written on a particular day. It does not seem like it should be rocket science to do this, but I am hitting a brick wall and have run out of ways to search google for where this has been solved elsewhere. Any help would be greatly appreciated.

[Phil_Seamark · Accepted solution]

Hi @pchilton

If you add the following calculated column to your 'Date' table, it will return a count or child rows from the 'WorkItemsView' table, so long as you have a relationship between the two tables

Created Date = COUNTROWS(RELATEDTABLE('WorkItemsView'))

[Phil_Seamark · Accepted solution]

Hi @pchilton

If you add the following calculated column to your 'Date' table, it will return a count or child rows from the 'WorkItemsView' table, so long as you have a relationship between the two tables

Created Date = COUNTROWS(RELATEDTABLE('WorkItemsView'))

[pchilton · Accepted solution]

Well, that was easy.  Thank you very much!