Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count

Hi,  I am struggling to visually show how many repeat investors there are in my data for different funds. I have made a sample data set here:  My goal is when I input another fund into this d...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Just a small change to mahoneypat  formula for your desired result.

     

    Fund Count =
IF (
    ISINSCOPE ( 'Table'[Name] ),
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Fund] ),
        ALL ( 'Table'[Fund] )
    ),
    CALCULATE (
        COUNT ( 'Table'[Fund] )
    )
)

     

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you mahoneypat 

 

This worked for the individual fund names, however, it says there are 4 investors in each of the funds. Is there a way to have that show the actual amount? 

 

Like shown in the picture below, it says 4 for all of them, when clearly there are 7 investors in Fund 3. 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Just a small change to mahoneypat  formula for your desired result.

 

Fund Count =
IF (
    ISINSCOPE ( 'Table'[Name] ),
    CALCULATE (
        DISTINCTCOUNT ( 'Table'[Fund] ),
        ALL ( 'Table'[Fund] )
    ),
    CALCULATE (
        COUNT ( 'Table'[Fund] )
    )
)

 

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!