cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BlastS Regular Visitor
Regular Visitor

DAX Count Help

BANA       A             P

 

02840.5
100
010
100


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)

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
BlastS Regular Visitor
Regular Visitor

Re: DAX Count Help

Solution: 

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

Re: DAX Count Help

Hi @BlastS,

 

Add the following measure to your report:

 

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

Regards,

MFelix



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




BlastS Regular Visitor
Regular Visitor

Re: DAX Count Help

Solution: 

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