Forum Discussion

MMQuestions7's avatar
MMQuestions7
Regular Visitor
3 years ago
Solved

Bar Chart sum total when slicer = Select All

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...
Need Help
  • HarishKM's avatar
    HarishKM
    3 years ago

    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's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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's avatar
MMQuestions7
Regular Visitor
3 years ago

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