DAX measure for Share of Total

[Tymok]

Hi,

I am not new to DAX and this is a very simple measure, but for some reason it does not work this time.
I want to calculate to the share of total for every category.
The measure:

Customer rating Share of Total (%) =

DIVIDE(

    [Customer rating count],

    CALCULATE(

        [Customer rating count],

        ALL('Customer Rating'[Rating])

    )

)

Output:

For my own sanity I tried it for a different measure, because I know this should work.
Measure:

DELETE Share of Turnover =

DIVIDE(

    [DELETE TEST Turnover],

    CALCULATE(

        [DELETE TEST Turnover],

        ALL('Product Category'[Product category])

    )

)

Output:

As you can see, the measure is basically the same and it works. 

Sometimes DAX drives me crazy with it's inconsistencies, can someone please explain why it does not work in the first example?
Thanks

[Greg_Deckler]

@Tymok Probably has something to do with your base measure. Would have to see both of them to determine if something in there is the cause. If you avoid CALCULATE you generally don't get these kinds of inconsistencies.

Customer rating Share of Total (%) =
  VAR __Rating = [Customer rating count]
  VAR __AllRating =
    SUMX( 
      ADDCOLUMNS(
        SUMMARIZE( ALL( 'Customer Rating' ), [Rating] ),
        "__Measure", [Customer rating count]
        ),
        [__Measure]
     )
  VAR __Result = DIVIDE( __Rating, __AllRating )
RETURN
  __Result

Bonus, you can troubleshoot it.

[johnt75 · Accepted solution]

I would guess that your customer rating column is sorted by a different column. You need to add that sort by column into the ALL function as well as the rating itself. The sort by column is used in the query behind the table visual, and so that column is in the evaluation context as well as the rating column.

[Tymok]

Thank you, this fixed it.
Never knew sort by different column could have these consequences.