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

    Hi lbendlin 

     

    With the second option you mention.

     

    The dax I am trying to reference has these 2 pieces:

     

    Non Duplicate Hours Process/Activity Numerator = 

SUMX(
    SUMMARIZE(
        Template,
        Template[Merged],
        Template[Hours by Year]
        ),       
        Template[Hours by Year]
)

     

    Could I have the if statetement incorporating these 2 measures within the dax?

     

    thanks.

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