Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Active Items, Open Tickets, Outstanding Items, Open Claims - All names for basically the same calculation. In this video, we will discuss how to use DAX to enable the count of any "Active" item. In the sample data, there is only a stage created date and no stage end date, so we first create a stage expire date as a calculated column, then leverage the new column in our Active Ticket measure. Finally, we will display our Active Ticket measure in a Gantt chart visualization created using a Power BI matrix.
Extract the Dax from the Blog Post
watch?v=LVvaUSIYCCg