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
johnt75's avatar
johnt75
Super User
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