Forum Discussion

MikeKKK's avatar
MikeKKK
Frequent Visitor
4 years ago

Classic workspace Usage Metric - Trend View calculation

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...
Need Help
v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

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.

VAR FirstHalfView = CALCULATE([ViewsCount], 'Date'[Date]<=MidDate)
VAR SecondHalfView = CALCULATE([ViewsCount], 'Date'[Date]>MidDate)
 
For more methods of optimisation, please refer to the following article.
 
Or you can use an external tool, DAX Studio, to check the performance of dax.


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.