Forum Discussion

EnSe's avatar
EnSe
Regular Visitor
1 year ago
Solved

Count rows based on date condition from another table

Hello @ all,   I'm just about to build a report in powerBI for a Jira Project-Reporting. For this I want to display a burndown chart showing the burndown of tasks starting from the project start-da...
Need Help
Tutorial Requests
  • johnt75's avatar
    johnt75
    1 year ago

    Make sure that there is no relationship between the date table and the issues table and then you can create a measure like

    Burn Down =
VAR MaxDate =
    MAX ( 'Date'[Date] )
VAR Result =
    CALCULATE (
        COUNTROWS ( 'Issues' ),
        'Issues'[Resolution Date] IN { BLANK (), MaxDate }
    )
RETURN
    Result
rohit1991's avatar
rohit1991
Super User
1 year ago

hi EnSe ,

 

  1. DAX Measure:
    Count of Issues =
    COUNTROWS(FILTER(Issue_list,ISBLANK(Issue_list[ResolutionDate]) || Issue_list[ResolutionDate] > SELECTEDVALUE(Date_table[Date])))

  2. This dynamically counts unresolved or future-dated issues.

  3. Visualize: Use Date_table[Date] on the X-axis. Use Count of Issues as the Y-axis in your burndown chart.