Forum Discussion
Custom Sort axis
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...
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
Dear Sam,
I have created the new measure but the "Total" amount does not automactically count and show in the chart