Bar Chart sum total when slicer = Select All

[MMQuestions7]

Hi, 

I'm facing this issue that I cannot group the customer total when my slicer = Select All

my bar chart displayed customer individually instead of sum total.
I would like to display my bar chart as below.

Anyone have idea or any solved similar issue that I can refer to?

Thank you.

[HarishKM · Accepted solution]

@MMQuestions7  Hey,
You can use like below measure to get result.

Total sale all = CALCULATE(SUM(financials[ Sales]),ALL(financials[Date]))

Total profit = CALCULATE(SUM(financials[Profit]),ALL(financials))

Thanks

Harish M

[amitchandak]

@MMQuestions7 , You follow my approach of single select with all , but you do not need single select.  Just leave it multi select . on Axis use the all column from new dim

Single Select with Select All : https://youtu.be/plGqCEZRfXU

[MMQuestions7]

Hi @amitchandak ,

How to change the customer name = "All Customer" in the chart when "ALL" selected in slices?

[MMQuestions7]

Hi @amitchandak , 
It doesn't work on my chart, the list of customers still displayed individually. Single select = off.