Including column from parent in Table visual messes up aggregation

Please see the attached excerpt: https://drive.google.com/file/d/1D24cyDv3Y9k2fY6EgtWAERFgWoA9uGxC/view?usp=sharing I have a formula that calculates which of the rows in the table is the latest v...

Need Help

Anonymous

5 years ago

Hi Anonymous,

You can create a measure as below:

Latest event date = 
CALCULATE (
    MAX ( 'Unit Revision'[Event Date] ),
    FILTER (
        ALLSELECTED('Unit Revision'),
        'Unit Revision'[Unit Id] = SELECTEDVALUE ( 'Unit Revision'[Unit Id] )
            && 'Unit Revision'[Event Date] >= MIN ( 'Calendar'[Date] )
            && 'Unit Revision'[Event Date] <= MAX ( 'Calendar'[Date] )
    )
)

Best Regards

Forum Discussion

Including column from parent in Table visual messes up aggregation

Related content

How to include multiple columns in Activator

Single Selection of aggregated columns

Data Aggregation issue

Power Query - Aggregate multiple columns within group by

include extra column - target