Forum Discussion

jburklund's avatar
jburklund
Icon for Helper III rankHelper III
3 years ago
Solved

Find overlap in table given a slicer value

I have a table of Investors which includes their InvestorID and which funds they have invested in ('FundName') and the year of the Fund ('FundYear'). I am trying to solve for, given a subject Fund (c...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    jburklund , You need to create an independent table with fund Name. Use that slicer and then you have measure below and use that with other column in visual

     

    All measure in table should follow the give approach or use measure as measure level filter

     

    Measure =

    var _tab = summarize(filter(Table, Table[FundName] in values(FundName[FundName] )), Table[InvestorID])
    return
    calculate(countrows(Table), filter(Table, Table[InvestorID] in _tab))

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

jburklund , You need to create an independent table with fund Name. Use that slicer and then you have measure below and use that with other column in visual

 

All measure in table should follow the give approach or use measure as measure level filter

 

Measure =

var _tab = summarize(filter(Table, Table[FundName] in values(FundName[FundName] )), Table[InvestorID])
return
calculate(countrows(Table), filter(Table, Table[InvestorID] in _tab))

 

  • jburklund's avatar
    jburklund
    Icon for Helper III rankHelper III
    3 years ago

    Thank you so much! This worked great and I know I will use this again.