Forum Discussion

shubhamsaha29's avatar
shubhamsaha29
Frequent Visitor
3 years ago

DAX Function for grouping/counting based on filters

Hello all, I need some help figuring out dax for this scenario I have this kind of table with duplicates:     I want to display count of incomplete workItems for specific sprints. It shou...
DAX
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi shubhamsaha29 

try to plot a visual with the sprint column and a measure like:

Incomplete = 
CALCULATE(
    DISTINCTCOUNT(data[WorkItemID]),
    FILTER(
        data,
        NOT "Closed" IN VALUES(data[State])
    )
)+0

it worked like:

  • shubhamsaha29's avatar
    shubhamsaha29
    Frequent Visitor
    3 years ago

    I tried this but it's not working as expected.


    Still getting a value which was closed in S01(Sprint 01 date range - 1/1/2023 to 15/1/2023).

    Ex:
    WorkItem 113 was closed in S01.
    It has was put to Dev on 1/3/2023 and also got Closed on 1/3/2023.

    So, Ideally WorkItem 113 should not be counted in S01 in the measure, as it was closed in S01.