Forum Discussion
Aggregate measure by value
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 |
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!
1 Reply
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!