Forum Discussion

ddorhout's avatar
ddorhout
Frequent Visitor
2 years ago
Solved

Cummulatives and including a legend

Dear all,   I am struggling with setting up a graph on cumulatives when including a legend... What I have until now: I have a table with various systems, customer group, including an index column...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi ddorhout 

    Based on your description, you can consider to put the customer group to a new table.(there is no relationship between tables)

     

    Table = SUMMARIZE(Master,[Customer Group])

     

    Then put this column to the legend and change the measure to the following.

     

    GoLive_Acc =
CALCULATE (
    COUNTROWS ( Master ),
    ALLSELECTED ( 'Master' ),
    Master[LiveDate] <= MAX ( Master[LiveDate] ),
    Master[Customer Group] IN VALUES ( 'Table'[Customer Group] )
)

     

    Output

    Best Regards!

    Yolo Zhu

    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
2 years ago

Hi ddorhout 

Based on your description, you can consider to put the customer group to a new table.(there is no relationship between tables)

 

Table = SUMMARIZE(Master,[Customer Group])

 

Then put this column to the legend and change the measure to the following.

 

GoLive_Acc =
CALCULATE (
    COUNTROWS ( Master ),
    ALLSELECTED ( 'Master' ),
    Master[LiveDate] <= MAX ( Master[LiveDate] ),
    Master[Customer Group] IN VALUES ( 'Table'[Customer Group] )
)

 

Output

Best Regards!

Yolo Zhu

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