Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all i am getting an error when i am trying to get count of closed projects.
Defn of Closed projects is Projects >=100%
@harshagraj , you can create a measure like
measure = CALCULATE(COUNT('report'[Project]),filter('report',[Average Status]>=1))
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])
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 )
)
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
99 | |
97 | |
73 | |
72 |