Remove filter with All function does not work when "sort by column"

[Adrian89]

Hi,

I experienced a problem with ALL function when trying to sum up sold value per month and then divide it to get average per month and then use it as a target in KPI visual. 

I used the format function to get Mth "Jan 2016" (FORMAT(Trans[DatePhysical];"mmm yy")) and then I sorted that column by another calculated column so I get the order of month correct. 
When adding fields into the KPI visuals it didn't work I used mth column as Trend Axis and two other Calculated measures into indicators and Target goal. In the calculated measure for the target goal I used the All function to remove the filter from mth.
In Excel PowerPivot the All function would be enough to to use in the Calculate function not to filter.

So what I found out was that it's not enough to just use ALL function on the column that you use in the table. You also need to use the ALL function on the "Sort by column" column to remove all filters.

As shown in the example below, when using testing5(Example 1) and testing6(Example 2) calculated measure.

Testing5 will remove all filters and give me average per mth and I can use it as a target goal, while testing6 fails.

Testing5 = CALCULATE(SUM(Trans[CostAmountPhysical]);ALL(Trans[Mth]);ALL(Trans[Mth seq]))/9

Testing6 = CALCULATE(SUM(Trans[CostAmountPhysical]);ALL(Trans[Mth]))/9

Sold per mth1 = CALCULATE(SUM(Trans[CostAmountPhysical]);DATESBETWEEN(Trans[DatePhysical];DATE(2015;09;01);EOMONTH(TODAY();-1)))Example 1, Correct view

Example 2, not working  

[MattAllington]

I have heard of the before - I think it is a bug.  Also you really should be using a calendar table.  Read about that here. 

http://exceleratorbi.com.au/power-pivot-calendar-tables/