Forum Discussion

sarikei's avatar
sarikei
Helper I
3 years ago
Solved

Sum Total

Hi, In my report, I have a Cluster Column Chart to display the last 12 months of Sales Volumn. So I can see the Sales Volumn of each month. How can I create the measure to sum all the Sales Volumn...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi sarikei ,

     

    Please create following measures:

    Sales = SUM('Table'[Sales Volumn])

TotalSales = CALCULATE(SUM('Table'[Sales Volumn]),ALL('Table'))

% = DIVIDE([Sales],[TotalSales])

     

    The result you want:

    Best regards,

    Yadong Fang

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

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi sarikei 

Please use the following measure:

ShareOfYear =

var var_CurrentValue = SUM(Table[Sales Volumn])
var var_ValueofYear = CALCULATE(SUM(Table[Sales Volumn]),ALL(Table[Month])
var var_ShareofCurrentValue = DIVIDE(var_CurrentValue,var_ValueofYear)

Return
var_ShareofCurrentValue

 

But first you have to split the Month Column in Power Query (see split by delimeter function) or additionally create a month and a year column so that you can use the initial column for other purposes. But in the end you should have a separate year column and a separate month column.

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

Mikelytics's avatar
Mikelytics
Resident Rockstar
3 years ago

Hi sarikei ,

 

sorry I have not read everything completely I think. So if want percentage of all rows then you should go with the solution of v-yadongf-msft .

 

If you only want to have the current year then you can use my solution.

 

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn