Cannot filter measure by available table columns

[Anonymous]

I am tasked to get the count of tickets that are going to be deployed to production and also the tickets already deployed during the last release date based on today's date.

So to get the previous release date, I created a variable _prevgzdate and then calculated the number of tickets >= that variable to get the total count. In here I am able to get the correct count needed.

previous GZ date :=

var _prevgzdate = CALCULATE(MAX(BusinessExecutiveDashboard[ProdTargetDateDP]),BusinessExecutiveDashboard[ProdTargetDateDP] < UTCTODAY())

return

CALCULATE(COUNT(BusinessExecutiveDashboard[Ticketnumber]),FILTER(BusinessExecutiveDashboard,BusinessExecutiveDashboard[ProdTargetDateDP]>=_prevgzdate))

Correct count:

The problem I have now is that I need to determine these tickets specifically by getting their details based on other available columns but when for example putting the ticket number in the visual, I get all other tickets even if they are not supposed to be included in those 23 calculated by the measure. Notice that in the image below, even those that does not have a date is reflecting 1 in the measure for some reason.

when in fact I should only get these:

Can somebody help?

[FreemanZ · Accepted solution]

hi @Anonymous 

try like:

previous GZ date :=

var _prevgzdate = 

CALCULATE(

     MAX(BusinessExecutiveDashboard[ProdTargetDateDP]),

     BusinessExecutiveDashboard[ProdTargetDateDP] < UTCTODAY()

)

return

CALCULATE(

     COUNT(BusinessExecutiveDashboard[Ticketnumber]),

     FILTER(

 BusinessExecutiveDashboard,

   BusinessExecutiveDashboard[ProdTargetDateDP]>_prevgzdate   //remove "="

    )

)

or 

previous GZ date :=

var _prevgzdate = 

CALCULATE(

     MAX(BusinessExecutiveDashboard[ProdTargetDateDP]),

     BusinessExecutiveDashboard[ProdTargetDateDP] < UTCTODAY()

)

return

CALCULATE(

     COUNT(BusinessExecutiveDashboard[Ticketnumber]),

     FILTER(

 BusinessExecutiveDashboard,

   BusinessExecutiveDashboard[ProdTargetDateDP]>=_prevgzdate

    &&NOT ISBLANK(_prevgzdate)

    )

)

[Wilson_]

Hello,

What happens if you filter out all blank ProdTargetDateDP values from the filter pane? Does that solve your issue?

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)