How to create a count of these columns

Questions & Answers
1

I have this table that shows me details on upcoming milestones. I want to create a seperate report that gives me a count of each of the following:

New Measure “Number of Milestones” = Count of Issue due date NOT Empty
New Measure “Number Forecasting Late” = Count of Gap (Due-Forecast Days) NOT Empty
New Measure “Number Past Due” = Count of Past Due Days NOT Empty

image
image1249×336 31.6 KB

2

Hi,

The standard measure “Issues with due date” should work for the first use case.

A custom calculation like this can count the issues that have the Gap greater than zero:

NonZero(Count(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Issues created]>0
    AND
    [Measures].[Gap (Due-Forecast Days)]>0
  )
))

You can use other measure in the condition to find nonempty count for other measure.

Kindly,