Forum Discussion

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
2 years ago

Count if with a measure

Hi   Is it possible to create a count if with a measure?   In the image below I have a capacity planning process with different activities (drilled down).         The rule is simple, i...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

I'd go with ITManuel 's approach.  Is that not sufficient?

o59393's avatar
o59393
Icon for Post Prodigy rankPost Prodigy
2 years ago

Hi lbendlin  ITManuel 

 

It shows empty:

 

 

 

Where:

 

Count IF 2 = 
VAR _T1 = 
FILTER (
    ADDCOLUMNS (
        VALUES ( Template[Facet] ),
        "@%", [Non Duplicate Hours Process/Activity 3]
    ),
    [@%] >= 0.8
)
VAR _Result = COUNTROWS ( _T1 )
RETURN
_Result

 

The table I am using has the following fields:

 

 

 

Any idea what could be wrong?

 

thanks.