Brian, thanks again for looking at this. I was able to get the Total to work if just one of the matrix switch items is selected by adding a BLANK() for the ELSE case of the matrix switch measure. If more than one is selected, a single total doesn’t make any sense. It would be nice to have the same hierarchy for the total column as for the store number, but as mentioned above, that might be a tall order.
I have not been able to make any progress in adding the location field to the column hierarchy dynamically. If I can get this working, then the Total issue above is somewhat moot, since I could just turn the store grouping off and see the total that way. I am attaching a scaled down version of my pbix file as requested. There is a selection in the upper left hand of the title bar with Store/Month/Quarter/Year which I would like to single-select and add that to the hierarchy. The pbix as is has the location added manually. I appreciate the help.
P&L Report.pbix (835.0 KB)