Forum Discussion

kkoc3karan's avatar
kkoc3karan
Frequent Visitor
3 years ago
Solved

Need Help with this DAX calculation

Data   CRM ID CRM Close Date Task ID Task Close Date 1 12/07/2023 1.1 14/07/2023 1 12/07/2023 1.2 15/07/2023 1 12/07/2023 1.3 16/07/2023 2   2.1 17/07/2023 2   ...
  • kkoc3karan's avatar
    3 years ago

    I have figured out however i am unsure if this is the most optimal way 

    happy for someone to suggest better way 

    countx(
        filter(
            summarize(
                    test,
                    test[CRM ID],
                    test[CRM Close Date],
                    "_1",
                    countrows(
                                filter(
                                        test,
                                        not isblank(test[Task Close Date])
                                )
                    ),
                    "_2",
                    countrows(test)
            ),
            isblank(test[CRM Close Date]) && [_1]=[_2]
        ),
        test[CRM ID]
    )