Forum Discussion

Helper I

4 years ago

Solved

Help

Hello all, Can anyone please help me to understand whats the mistake I'm making in the following DAX formula: Site Visits = COUNTROWS( SUMMARIZE('4. CoW Productivity', '4. CoW Productivity'...

Need Help

Anonymous
4 years ago
Hi SantiagoTorres ,

Sorry for my late reply.

Try this

Site Visits = COUNTROWS(DISTINCT('4 CoW Productivity'))

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
countrows.pbix42 KB

Fowmy

Super User

4 years ago

SantiagoTorres

Can you apply the following modified meaure?

Site Visits =
SUMX (
    VALUES ( '4. CoW Productivity'[Assignee(S)] ),
    COUNTROWS (
        SUMMARIZE (
            '4. CoW Productivity',
            '4. CoW Productivity'[Project Number],
            '4. CoW Productivity'[Date Created]
        )
    )
)

SantiagoTorres
Helper I
4 years ago
Hi, thank you so much for your response,

I already applied this formula:

Site Visits =
SUMX(
VALUES('4. CoW Productivity'[Assignee(S)]),
COUNTROWS(
SUMMARIZE(
'4. CoW Productivity',
'4. CoW Productivity'[Project Number],
'4. CoW Productivity'[Date Created]
)
)
)

And I get these results,
What you think??

Many thanks,

Andres Torres