Too many measures?

[swebb]

All,

I am creating an enterprise finance report for my organization, and one of the things I'm running in to is creating a completely custom finance report has lead to a lot of measures. ~56 measures per company (we have 5, so 56x5 roughly = 280 measures). Will this be a problem for the report? It is broken down by company/country so the one report has 5 different sub pages for each entity. 

Second question, is how do I copy the measures en masse? I need to do this for each company and doing it one by one is pretty tedious. Any thoughts here?

[Greg_Deckler]

@swebb First, I'm not sure why you would need a different measure for each company versus one measure that does the calculation and using slicers/filters. Second, you could use my tool MSHGQM to quickly create templates for your measures or even DAX Editor to create copies of your measures with a single click. You can download those here.

GitHub - gdeckler/MicrosoftHatesGregsQuickMeasures: Microsoft Hates Greg

If you have an Enterprise DNA subscription, there is a single download for Pro versions of all the tools and it's included in your subscription.

[swebb]

As an aside, I have 2 of your books sitting on my desk, I just haven't made it through them yet 🙂 

[swebb]

I have a consolidated table, in USD and then each other table in EUR and CAD for example. The end user is wanting to see the data specific to each company and their respective currencies. Admittedly, I'm very new to Power BI, so I'm probably not doing it the best way.