Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to compare the portfolio composition for 2 mutual funds. The holdings information for both funds is in the same table.
On the top I have the % holding for each instrument within each fund showing all instruments.
On the bottom I want the left and right charts to show only the instruments that the other fund does not own. And in the middle I want to show the % holding of the instruments that both funds hold.
Right now, I've created a filter for each of the 3 charts making each interact with only 1 chart and selecting the instruments in each group manually. in order to demonstrate the end result I want.
Is there a way I can do this with measures?
Hi @Johnsnowlife,
Yes, there should be a way to do it with measures. But we can't create a measure without data and its structure. Could you please post a sample here in text mode? (pbix file would be great). The measure could be like this:
Measure = CALCULATE ( SUM ( 'table'[value] ), FILTER ( 'table', COUNT ( 'table'[InstrCode] ) >= 2 ) )
Best Regards!
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |