Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative Measure in Line and clustered column chart

Dear Community,  I am trying to do multiple cumulative curves together with bars in a Line and clustered column chart.  The bars are working fine but cant get the cumulative measures to work.  Pro...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    The solution was as followed:

     

    Dax Code:

    Curve Hours Gate Baseline = 
CALCULATE(
SUM('Table Name'[Hours]),
FILTER (ALLSELECTED('WPPMDBext1P_Q'), 
'Table Name'[DataType]="Gate Baseline"),

FILTER(
		ALLSELECTED('Table Name'[Month-Year]),
		ISONORAFTER('Table Name'[Month-Year], MAX('Table Name'[Month-Year]), DESC)
))

    Result:

     

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Anonymous ,

 

It may be caused by the slicer, or it may be caused by other measures in the visual.

Will the lines in the visual be displayed correctly if you remove the slicer?

Please provide a sample .pbix file.

 

Best regards,
Lionel Chen

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