Forum Discussion
Disable SEE RECORDS
- 5 years ago
Anonymous First of all there is no performance issue if you create an explicit measure and as mentioned, as a best practice you want to explicit measure (make a habit of it), may be this report has only 1-2 visuals/pages but think about the bigger picture, if you are working on a larger project, complex reports, etc, having implicit measure will be a nightmare, it is more about following the best practice and making a habit.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- 5 years ago
Anonymous imagine the following scenario:
- You need to create a visual that shows sales, so you drag the sales field into your visual. It works.
- You create 3 visuals that use this method, and conditionally format one of them as a matrix with bars on the values.
- Your boss comes in and says "We actually need to know what the gross collections are, so please include sales tax in your visuals.
- You now have to create an explicit measure that is SUM(Sales[Sales]) + SUM{Sales[Sales Tax]), then remove all of your implict measures, add this new measure in, and redo any conditional formatting.
Had you created the explict measure to start with = SUM(Sales[Sales]) the only thing you would have had to do is edit the measure to the new formula, and all visuals everywhere would automatically update.
Also, you cannot create pivot table in Excel that use implicit measures when you use the new connect to Power BI dataset. It currently only allows you to add explicit measures to value fields.
As parry2k indicated, this isn't really right or wrong, but best practice. Your future self will thank you for it.
Anonymous you always want to create an explicit measure. It is best practice for a number of reasons. So even something as simple as:
Total Sales = SUM(Sales[Sales Amount])
Is better than dragging the [Sales Amount] field to the Values section.
You can also disable in a visual what the users can do. You can turn the visual header off so there is no ellipses icon to view.
Within a report there are options you as the publisher can set too. In Power BI Desktop, select the Options menu, then:
Within the tenant settings, you can enable and disable export options for the entire org if you are a Power BI Admin. There are many more options if you scroll down.
But that really has little to do with creating explicit vs implicit measures. You should always create measures for your data vs dragging data fields in to the VALUES section of a visual.