Forum Discussion

BlastS's avatar
BlastS
Helper I
7 years ago
Solved

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)

 

 

 

 

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)

2 Replies

  • 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)