March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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 (chosen by a slicer), how many investors overlap between each Fund in the Table and the Subject Fund.
I tried to make a calculated table filtered by a parameter, but I have to use imported data and so I couldn't get the calculated table to filter dynamically with the parameter. I know I need to create essentially a filtered table by the Subject Fund and check if each investor record ('InvestorID') exists in the filtered table and the Input Data table so I can get my "Investors from Subject Fund" count. My report is much more complicated than this but I've included a sample set of data below.
Solved! Go to Solution.
@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 , 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))
Thank you so much! This worked great and I know I will use this again.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
124 | |
89 | |
86 | |
70 | |
51 |
User | Count |
---|---|
206 | |
150 | |
97 | |
78 | |
69 |