Forum Discussion
Sorting by another column measure doesnt work correctly
Hi, i'm new in pbi, and im trying to perform delta calculations between my columns. I did it and finished my measure, like bellow: DIFF =
VAR _PE = CALCULATE(SUM(BASE_TOTAL[VALOR]), BASE_TOT...
Hi Anonymous ，
It seems illogical that you mention that there are no values in VERSAO, but then sort them. My guess is that you are trying to sort based on PE,RF. For PE, it should be 34.86, 33.44, 31.97. so you may need to add a new calculated column. Then use this calculated column to sort the diff.
rank = RANKX('Table',[diff],,DESC,Skip)
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I have that scenario, on delta columns in the begin of my matrix, i need them in the end, so i have this column order:
And i need this:
When i said no values in column value, i referred to my db. Like this:
My diff measure assign values to them ⭡