PowerPivot Forum

The code for the Variable measure does not align with the code for the 2 measure approach, using different tables and fields (see Date comparison at end of second measure).

Could this be the reason?

Thanks Matt, appreciate it.

Hi Matt,

Do you have an opinion on what specs are needed for a laptop to use for developing Power BI / Power Pivot models?

Can you share what machine you are using or lusting after to use?

Cheers
Phil

Hi, the attached might put you in the right direction. 1. Add an Index Column 2. Add columns for Count, List, Units that will become your column headings, concatenating "Count", "List", "Units" to the [Index] 3. Select each new column in turn (not together) and Pivot th...

Great work getting through the book and wanting to learn more. There are a host of sources of DAX / Power Pivot / Power BI online, Google will help you locate them. One such site is SQLBI, it has a site DAX Patterns section that provides DAX measures to solve real needs. Check it out at http://www.d...

Just wanted to say this solution keeps on giving, thanks very much.

Cheers
Phil

Hi, What you are after is one calculation on the Category rows and another on the Country subtotals, is that correct? On the Category rows you want [Company Sales Weight] x [Category Market Growth] and on the Country row you want the SUM of the value in the Category rows. This required is beyond my ...

This might be of use, but need to understand how you arrive at your expected results as this is producing different ones.

Perhaps you can explain the calc that gets 3.3%. Category Market Growth (Weighted) = Company Sales Weight x Category Market Growth At the Country level = 100% x 3% (your figure) which equals 3%, not 3.3% Also, at the country level, how did you get 3% for Category Market Growth? Current year = 1027, ...

The exercise asks to find sales of products that have some sales but less than $10k.

The && [Total Sales Amount}>0 is satisfying the "some sale" aspect of this.