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!

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
6 years ago

You could write a Fund Count measure like this and use it instead of your count measure.

 

Fund Count =
CALCULATE ( DISTINCTCOUNT ( Table[Fund] ), ALL ( Table[Fund] ) )

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

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!