Need help on calculated column

[Anonymous]

Project	Code	Flag
1	A	1
1	B	1
1	C	1
2	B	1
2	C	1
3	D	0
3	F	0
3	Q	0
4	B	1
5	A	0
6	C	0

I want to create a caculated column Flag, If project contains Code B then all records in project will be flgged as 1.  By the way, If the requirment is measure,how to create?

[Ashish_Mathur]

Hi,

This calculated column works as well

=if(CALCULATE(COUNTROWS(Data),FILTER(Data,Data[Project]=EARLIER(Data[Project])&&Data[Code]="B"))>0,1,0)

Hope this helps.

[Greg_Deckler · Accepted solution]

@Anonymous Maybe:

Column = 
  VAR __Project = [Project]
  VAR __Codes = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Project]=__Project),"Code",[Code]))
RETURN
  IF("B" IN __Codes,1,0)

Measure =
  VAR __Project = MAX([Project])
  VAR __Codes = DISTINCT(SELECTCOLUMNS(FILTER(ALL('Table'),[Project]=__Project),"Code",[Code]))
RETURN
  IF("B" IN __Codes,1,0)

[Anonymous]

@Greg_Deckler  Thanks a lot, it worked perfertly