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.

2 Replies

  • 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.