Forum Discussion

CarlSagan's avatar
CarlSagan
Icon for Helper II rankHelper II
1 year ago

Many to many relationship causing summation to rollup incorrectly

I have a dimension table called investment_selections and a transactional table called assets. When I put asset records in a table that does not contain investment_selection properties, the running t...
Need Help
CarlSagan's avatar
CarlSagan
Icon for Helper II rankHelper II
1 year ago

Simple

assets_running_total_date_table = 
CALCULATE(
    [assets_total],
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] <= MAX('Date'[Date])
    )
)