Need help with Formula

Hi Anonymous

You could add the following Measure

New Measure = CALCULATE(
				SUM('Table'[value]),
					'Table'[Data]="Projects"
					)

 or add a column like this

New Column = IF('Table'[Data]="Projects",'Table'[value],BLANK())

I reckon the measure is the better way to go :)

Phil I need one more help, I am trying to create a line and stacked chart with the below data and as shown in the Image1 I have created the stacked part, But I want the values of Login User as the line and the Login user should be excluded from the stacked columns as shown in Image2, how to acheive this?

Please try this measure and add it to the line values of your visual.

Logged in Users = CALCULATE(
		SUM('Table'[value]),
		FILTER(
			ALLEXCEPT('Table','Table'[Month]),
			'Table'[Data]="Login Users")
			)