Forum Discussion

smbolster's avatar
smbolster
Frequent Visitor
8 years ago
Solved

Problem With Calculate Measure

I'm having an issue with max date in a calulate measure that seems like it should work.   The measure I'm starting with is as follows:   Months In Selection= CALCULATE(COUNTROWS(VALUES('Real Date...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    smbolster

     

    Try this

     

    Months In Selection New =
CALCULATE (
    COUNTROWS ( VALUES ( 'Real Dates'[Date Accounting Period] ) ),
    FILTER ( ALL ( 'Real Dates' ), 'Real Dates'[Date] <= [Max Accounting Period] )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

smbolster

 

Try this

 

Months In Selection New =
CALCULATE (
    COUNTROWS ( VALUES ( 'Real Dates'[Date Accounting Period] ) ),
    FILTER ( ALL ( 'Real Dates' ), 'Real Dates'[Date] <= [Max Accounting Period] )
)
  • smbolster's avatar
    smbolster
    Frequent Visitor
    8 years ago
    Months In Selection New = CALCULATE ( COUNTROWS ( VALUES ( 'Real Dates'[Date Accounting Period] ) ), FILTER (VALUES ( 'Real Dates'[Date Accounting Period] ), 'Real Dates'[Date Accounting Period] <= [Max Accounting Period] ) )

    That helped steer me, this is what i used, which allowed filters on the screen to work, like if i pick 2017 it returns 12.

     

    Thanks