DAX Count Help

[BlastS]

BANA       A             P

0	284	0.5
1	0	0
0	1	0
1	0	0

How can i make a count of the number of BANA where the BANA is 1 when Column A last row > 100 

The output of that should count 1  the ( second row since column A was >100 on last row)

[MFelix]

Hi @BlastS,

Add the following measure to your report:

Count of Failures = CALCULATE(COUNT(Table2[Failure]); Table2[A] > 100)

Regards,

MFelix

[BlastS · Accepted solution]

Solution: 

BANA = IF([BANA]=1 && MAXX(FILTER('Table',[Index]=EARLIER([Index])-1),[A])=.5,1,0)