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

You cannot measure a measure directly. Either materialize it first, or create a separate measure that implements the entire business logic.

 

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

lbendlin 

 

Think I am getting closer:

 

 

Any idea here why the red shows up ?

  • 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.

       

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

      Hi lbendlin 

       

      Any idea here how to fix?

       

       

       

      thanks.