Custom Sort axis

[YYlee]

I want to remove the 1.2.3. (which I added manually in the database) and sort by Delivery, CE, Firm, and Total. I’ve created a custom sort table to define the sort order. However, I think because the "Total" is created using a measure (as shown above), and I’ve linked the 311 category total to the new table and selected it on the axis, the "Total" is not appearing on my clustered chart.

What steps should I take to remove the 1.2.3. and ensure that the "Total" is displayed correctly?

Thanks. 

Regards, 

YY

[SamWiseOwl]

Hi @YYlee 

Can you show us the measure please.

My guess is you need to remove the new filter caused by the sorting column.

For example if I had the Month Name and sorted by the Month Number I have to remove both filters to return the total:

All Month sales =
Calculate( [Sum Quantity], AllSelected(calendar[Month],Calendar[Month Name])

[YYlee]

Hi Sam,

Which measure you mean?

[SamWiseOwl]

Hi @YYlee this one:
However, I think because the "Total" is created using a measure

[YYlee]

Measure 2 = if(SELECTEDVALUE('New Table'[Categories])="Total",CALCULATE(SUM('Total'[Week per month]),ALL('New Table'[Categories])),SUM(Total[Week per month]))

[SamWiseOwl]

Hi @YYlee I would assume something like this:
Total Measure = 
if(
SELECTEDVALUE('311 category total[311 category total])="Total" --if new column is total
,CALCULATE(--Change the filters

                  SUM('Total'[Week per month]) --sum this

                         ALL('311 category total')) --remove the filter from new table

,SUM(Total[Week per month])) --Otherwise sum current filter

[YYlee]

Dear Sam, 

I have created the new measure but the "Total" amount does not automactically count and show in the chart