Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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!
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!
User | Count |
---|---|
100 | |
89 | |
82 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |