Report Portal

Organizing Your Measures With a "Dummy" Table

I have the addition of the "Measure Grid" (aka "Calculation Area") in V2 to be of mixed benefit. Yes, it is great to have access to your measures from within the PowerPivot Window, but the manner that they did so is so very. messy.

I like to keep my spreadsheets hyper-organized and clean, because often I have to pass them off to someone else who has to be able to understand what I am doing. So I have come up with a workflow to take advantage of the measure grid while retaining a logic to the location of my measures.

Read more...

Tags: design, dax, tabular

 

2007-2015 VidasSoft Systems Inc.