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.