In our first foray to provide measures in Power Pivot / BI we admittedly created less than optimal constructs - which in some cases weren't even accurate 100% of the time.
So we reached out to the best in the business - Marco Russo. As a result, we have the most efficient and accurate DAX methodology we could possibly provide, and you can find more information by visiting his DAX Patterns website where he and partner Alberto Ferrari have published their works online.
This means you don't have to rely on how we did things.
We followed these strategies:
Here is a list of measure categories which exist in QQube Version 10 for Power Pivot and Power BI
Power BI allows us the option of segmenting a list of Measures into Folders, to help customers quickly find their fields.
Certain Measure Categories exist in almost every data model as highlighted in yellow below:
Automatically hidden (as shown in red):
is requesting access to a wiki that you have locked: https://clearify.com/wiki/view/6175/dax-methodology