I am trying to create a visualization that shows current asset allocation and the delta from the target allocation. The measures don’t work appropriately when I use the lookup tables to create filter context. For example, creating a matrix using Asset Name from the security lookup table and total market value measure returns a sum total without listing any of the asset names.
I ultimately want to show what the portfolio of securities needs to do (buy or sell) in order to arrive at the target allocation referenced by the allocation target table. I’d like to be able to filter this in multiple ways. By Account, Class, Segment, Asset or a combination of each. I think part of the complication arrives because the securities in the target allocation may not exist the current allocation.
As a note, the short term target allocation is interchangeable and all values are currently 0%. The long term target allocation is a static figure.
Thanks so much for your consideration on this!
Securities Roadmap Dashboard.pbix (398.8 KB)