Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago
Solved

Sumx returning wrong value

Hi all   I've been trying hard to get this sum correct but still not able.   The dax measure called count if is not returning me the right sum in the matrix below:   The statement is simp...
Need Help
Show and Tell
  • o59393's avatar
    o59393
    Post Prodigy
    2 years ago

    Hi lbendlin 

    The image is cut, can you please paste the dax?

     

    So far I have:

     

     

     

    Count IF = 

COUNTROWS(
    FILTER(
        ADDCOLUMNS(
            SUMMARIZE(
                Template, Template[Facet], Template[Area], Template[Tier 1: Process Facet], Template[Tier 2: Activity Facet]),"S",[Non Duplicate Hours Process/Activity 3])
))

     

     

     

     

    Thanks.

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      i added the pbix too.

      • o59393's avatar
        o59393
        Post Prodigy
        2 years ago

        you rock! lbendlin