Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Summing a legend in stacked column chart

Hey guys,   I have this chart below   I want to be able to have each month summed up like June Total days : 9   The setup I have is this     
Need Help
Show and Tell
Tips and Tricks
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Anonymous ,

     

    You can create a measure using dax as below:

    Result =
CALCULATE (
    SUM ( Table[TimeCompletedDays] ),
    ALLEXCEPT ( Table, Table[RecordDate].[Month] )
)

    Community Support Team _ Jimmy Tao

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

The setup I have is this:

 

Axis:

RecordDate

   Month

 

Legend:

Client

 

Value:

TimeCompletedDays

 

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

You can create a measure using dax as below:

Result =
CALCULATE (
    SUM ( Table[TimeCompletedDays] ),
    ALLEXCEPT ( Table, Table[RecordDate].[Month] )
)

Community Support Team _ Jimmy Tao

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