why does sorting not work

[Anonymous]

I calculated the difference YOY% but can't sort on it?  it sorts just fine by pipeline or pipeline ly or by diff yoy actual but not by diff yoy actual %.  as you can see when I try to sort the data for pipeline last year disapears.

Pipeline = sum('Combined Data'[Pipeline data])

Pipeline LY = CALCULATE([Pipeline],SAMEPERIODLASTYEAR(calendar[date]))

diff YOY Actual = ([Pipeline]-[Pipeline ly])

diff YOY actual % = [diff YOY Actual]/[Pipeline LY]

[v-xiaotang]

Hi @Anonymous 

could you accept the answer as solution  so the others can find it more quickly.

really appreciate!

Best Regards,

Community Support Team _Tang

[v-xiaotang]

Hi @Anonymous 

Hi, you made a mistake about their order, not because you sorted it and column [pipeline ly] disappeared, but because some data in column [pipeline ly] did not exist, the corresponding data in column [diff YOY actual %] was infinite. I looked at your results and there is no problem with sorting.
Moreover, the blanks in column [pipeline ly] really shouldn’t show any values.

Any question, please let me know. 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I calculated the difference YOY% but can't sort on it?  it sorts just fine by pipeline or pipeline ly or by diff yoy actual but not by diff yoy actual %.  as you can see when I try to sort the data %, last year disapears.

Pipeline = sum('Combined Data'[Pipeline data])

Pipeline LY = CALCULATE([Pipeline],SAMEPERIODLASTYEAR(calendar[date]))

diff YOY Actual = ([Pipeline]-[Pipeline ly])

diff YOY actual % = [diff YOY Actual]/[Pipeline LY]