Forum Discussion

SantiagoTorres's avatar
SantiagoTorres
Icon for Helper I rankHelper I
5 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's avatar
    Anonymous
    5 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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
5 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's avatar
SantiagoTorres
Icon for Helper I rankHelper I
5 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