Calculate has been used in a TRUE/Faslse- Need count of project

[harshagraj]

Hi all i am getting an error when i am trying to get count of closed projects.
Defn of Closed projects is Projects >=100%

Column = CALCULATE(COUNT('report'[Project]),[Average Status]>=1)
[Average Status] is a measure and [Project] is a column.

I need to display total closed projects in a card visual.

[amitchandak]

@harshagraj , you can create a measure like

measure = CALCULATE(COUNT('report'[Project]),filter('report',[Average Status]>=1))

[Greg_Deckler]

Maybe [Average Status] has a CALCULATE in it?

Maybe try:

Column =

VAR __Table =

  ADDCOLUMNS(

    'report',

    "Average Status" = [Average Status]

  )

RETURN

  COUNTX(FILTER(__Table,[Average Status]>=1),[Project])

[jdbuchanan71]

@harshagraj 

You will need to use a FILTER to do the comapre to the the measure like so.

CALCULATE (
    COUNT ( 'report'[Project] ),
    FILTER ( VALUES ( 'report'[Project] ), [Average Status] >= 1 )
)