Forum Discussion

gsed99's avatar
gsed99
Icon for Helper III rankHelper III
8 years ago
Solved

Count formula with filter for Max Year

Hello,

I am trying to do a count on # of records, but based on a filter for the year. What I essentialy want to say is count # of SAO Date when SAO Year=MAX (meaning current year). Both SAO Date and SAO Year are separate columns/data points.

I think I am close but, I am new to Power BI, so looking for some guidance.
Thank you,

Greg

Need Help
  • jmalone's avatar
    jmalone
    8 years ago
    Current Year SAO Records :=
CALCULATE (
    COUNT ( 'TableName'[SAO Date] ),
    FILTER (
        ALL ( 'TableName'[SAO Year] ),
        'TableName'[SAO Year] = MAX ( 'TableName'[SAO Year] )
    )
)

15 Replies

  • jmalone's avatar
    jmalone
    Icon for Resolver III rankResolver III
    8 years ago
    Current Year SAO Records :=
CALCULATE (
    COUNT ( 'TableName'[SAO Date] ),
    FILTER (
        ALL ( 'TableName'[SAO Year] ),
        'TableName'[SAO Year] = MAX ( 'TableName'[SAO Year] )
    )
)