Cumulative Measure in Line and clustered column chart

[Anonymous]

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. 

Problem is that it dosent seems to be able to show the data on the same time. 

What i would think would happen is the following on top of the bars:

 But what happens is the following:

As you can see the lines are on top of each other. Next to the graph the data for the 4 diffrent lines is precented , even thoe it shows them in the ledged the the data is empty. If the filter is changed to only show one type of data it works. 

The following measure is used for the 4 lines, the only thing that changes is the "DataType":

Measure:

Curve Hours Gate Baseline = 
IF (FIRSTNONBLANK('Table Name'[DataType], 1)="Gate Baseline",
CALCULATE(CALCULATE(
	SUM('Table Name'[Hours]),
	FILTER ('Table Name', 'Table Name'[DataType]="Gate Baseline")),
	FILTER(
		ALLSELECTED('Table Name'[Month-Year]),
		ISONORAFTER('Table Name'[Month-Year], MAX('Table Name'[Month-Year]), DESC)
	)
)
,BLANK())

Table Data:

[Anonymous · Accepted solution]

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]

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.

[amitchandak]

@Anonymous , Not very clear.

Try like

CALCULATE(
SUM('Table Name'[Hours]),
FILTER (ALLSELECTED('Table Name'), 'Table Name'[DataType]="Gate Baseline" && 'Table Name'[Month-Year] = MAX('Table Name'[Month-Year]))
)

[Anonymous]

The code:

Curve Hours Gate Baseline = CALCULATE( SUM('Table Name'[Hours]), FILTER (ALLSELECTED('Table Name'), 'Table Name'[DataType]="Gate Baseline" && 'Table Name'[Month-Year] = MAX('Table Name'[Month-Year])) )

Works now the data is precented on top of the other data but not working as a cumulative line.

Current:

Expected:

Any ides? I have tryed to use ISONORAFTER and EARLIER but that what gave me the problems to start with.

Thanks for the help so fare

[Anonymous]

Hi Amiitchandak, 

Thanks for the fast response, im getting the following belowm is this due to the &&?

Some one wrote you could just bracket the holee thing but would this be correct?

Error:

To use special characters in a column name, enclose the entire name in brackets ( [] ) and add a ] to any closing brackets in the name.

(Edited a simple mistake from my side forgot // Name = \\ in the top (Beginner mistake))