Forum Discussion

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

lbendlin
2 years ago

COUNT_IF.pbix278 KB

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])
))