Forum Discussion
SWITCH function for P&L Statement
Like many others, I'm trying to build a P&L statement but have hit a wall. My goal is to include "calculated rows" in a matrix such as the following: PLID Category 0 Gross Reve...
Can you provide more details about your model and measures? What your doing should work, my guess its probably has to do with mulitple fact and lookup tables and the filter context not being applied the way you want. Ideally a sample PBIX with model and representative data vs actual data or at least pic of Model with relationsips and definitions of some of these measures you reference. and layout of matrix/visuals your trying to use.