Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Happy New Year everyone!
I need a help on customised Power BI usage metric report.
I am using live connection to Usage Metrics dataset (classic workspace)for my customized usage report, and I would like to have "View Trend" (it is only available in new workspace usage metric dataset.)
The view trend reflects view count changes over time. It compares the first half of the selected time period with the second half.
Thus, I created a measure as below:
Hi @MikeKKK ,
I recommend you to check the startdate and enddate of each report if they are all the same. Because the relationship between 'Date' table and other report table is one to many and the cross filter direction is single.
Then in your code, maybe the following code is better.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@MikeKKK , Try with this change
View Trend =
VAR StartDate = MINX(allselected(Dates) ,Dates[Date])
VAR EndDate = MAXX(allselected(Dates) ,Dates[Date])
VAR PeriodHalfDaysCount = INT((MAX(Dates[Date])-MIN(Dates[Date]))/2)
VAR MidDate = StartDate+PeriodHalfDaysCount
VAR FirstHalfView = CALCULATE([ViewsCount], DATESBETWEEN(Dates[Date],StartDate,MidDate))
VAR SecondHalfView = CALCULATE([ViewsCount], DATESBETWEEN(Dates[Date],MidDate+1,Enddate))
RETURN DIVIDE (SecondHalfView-FirstHalfView,FirstHalfView)
@amitchandak I can see you have changed the Variable StartDate and EndDate , how does this help?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
56 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |