Forum Discussion

cgarg's avatar
cgarg
New Member
1 year ago
Solved

DAX Formula for Counting Column Values from Previous Day Returns Blank Output

Hi Team, Consider the below table abc: status              dateend (mm/dd/yyyy) Success           01/01/2023 Success           01/02/2023 Success           01/02/2023 Failure             01/08/...
"DAX help"
  • cgarg's avatar
    cgarg
    1 year ago

    Hi  ,Thank you for your response. This doesn't workout for me either (probably because the dataset I've is huge having several columns & multiple values even for 'status' column & hence conditions are failing). However, below is the dax formula that worked for me:
     

    test =

    CALCULATE(

       COUNT(abc[status]),

        CalendarTable[Date] = MAX(CalendarTable[Date]-1)

       )

    I've explicitly set the status filter to Success from filters pane.

     

    I'd like to thank the community for taking pro-active efforts in resolving the issue. Thank you once again!

    Anonymous

pcoley's avatar
pcoley
Icon for Super User rankSuper User
1 year ago

cgarg 
Please try with this measure:

CountSuccessPD =
CALCULATE (
    COUNTROWS ( abc ),
    PREVIOUSDAY (
        ALLSELECTED ( CalendarTable[Date] )
    ),
    abc[status]="Success"
)

I hope this helps, if so please accept as a solution. Kudos are welcome😀