Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 )
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.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |