Aggregate measure by value

[diego-jd]

I am using the Usage Metrics Report dataset to create a Dashboard. There, I created the measure days_without_views, that calculates the days that have passed since the report was last seen with this formula:

days_without_views = DATEDIFF(MAXX(
    KEEPFILTERS(VALUES('Views'[Date])),
    CALCULATE(MAX('Views'[Date]))
), TODAY(), DAY)

In the report table I created a column called Area. Each report belongs to a certain area (Marketing, Finance, etc.)
What I want to do is, in any visualization (table, graph, etc.)  obtain the sum of days_without_views by area. When creating a table and putting area and days_without_views it seems to grab just a single value instead of summing it .

Aggregated table

Area	days_without_views
Marketing	1
IT	3
Finance	2

Data

Report	Area	days_without_views
Report 1	Finance	3
Report 2	Finance	2
Report 3	Marketing	1
Report 4	Marketing	8
Report 5	Marketing	2

[Anonymous · Accepted solution]

Hi @diego-jd 

You may create a new measure as below, which uses your current measure for each area

total =
VAR vtable =
    SUMMARIZE (
        'ReportTable',
        'ReportTable'[Report],
        'ReportTable'[Area],
        "days", [days_without_views]
    )
RETURN
    SUMX ( vtable, [days] )

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!