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

I also tried to do it this way: 

I edited the interactions so that the top left slicer (Fund) would filter the bottom left slicer(investor), but when I click "select all" on the bottom left slicer, it gives me all of the investors name in that matrix, not just Fund 1's investors.