Forum Discussion

chrismcdonald's avatar
chrismcdonald
Helper I
6 years ago
Solved

Dates rolled up to Project level

Hello,   I am looking for help again please.   I am trying to create a view table that shows a roll up of dates to a project level for the Construction Complete activity   Example Data Proj...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi chrismcdonald ,

     

    Is the following image your expected result?

    You need to edit the measure "Actual1".

    Actual1 =
IF (
    CALCULATE (
        COUNTBLANK ( 'Table'[Actual] ),
        ALLEXCEPT ( 'Table', 'Table'[Project #] )
    ) > 0,
    BLANK (),
    CALCULATE ( MAX ( 'Table'[Actual] ), ALLEXCEPT ( 'Table', 'Table'[Project #] ) )
)

     

amitchandak's avatar
amitchandak
Super User
6 years ago

chrismcdonald 

use the measure in table, it should filter

Measure = 
VAR __id = MAX ( 'Table'[Project #] )
VAR __date = CALCULATE ( MAX( 'Table'[Forecast] ), ALLSELECTED ( 'Table' ),  'Table'[Project #] = __id ) 
RETURN CALCULATE ( count ( 'Table'[Project #] ), VALUES ( 'Table'[Project # ), 'Table'[Project #] = __id, 'Table'[Forecast] = __date )