Sort Matrix visual by custom Measure Percent (Month over Month)

[undergreat]

I have a matrix table where I have a MoM Percentage difference compared to the previous month. But when sorting Ascending or Descending by the Percentage Difference Column, the values are nor sorted correctly. 

Does someone know why? I've noticed this behaviour a few times - alwys with % calculations.

Measure:

MoM % - Cost p. Conversion = 
VAR lastWeekAmount =
    CALCULATE (
        SUM('00 - Adwords Keyword Merge'[Cost])/1000000/SUM('00 - Adwords Keyword Merge'[Conversions]),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[CurMonthOffset]
                = MIN ( 'Calendar'[CurMonthOffset] ) - 1
        ))
RETURN
    DIVIDE ( SUM('00 - Adwords Keyword Merge'[Cost])/1000000/SUM('00 - Adwords Keyword Merge'[Conversions]) - lastWeekAmount, lastWeekAmount, 0 )

[v-piga-msft]

Hi @undergreat，

In matrix, it only supported sort by total value.

It seesm that your requirement is not supported currently. There is an idea about that, you can vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13808061-matrix-sort-columns-by-v...

Best Regards,

Cherry