Forum Discussion

BlastS's avatar
BlastS
Helper I
7 years ago
Solved

DAX Count Help

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 t...
Need Help
Show and Tell
Tips and Tricks
  • BlastS's avatar
    BlastS
    7 years ago

    Solution: 

    BANA = IF([BANA]=1 && MAXX(FILTER('Table',[Index]=EARLIER([Index])-1),[A])=.5,1,0)
MFelix's avatar
MFelix
Super User
7 years ago

Hi BlastS,

 

Add the following measure to your report:

 

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

Regards,

MFelix

BlastS's avatar
BlastS
Helper I
7 years ago

Solution: 

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