![]() Now, having said that, I believe it is useful to refer to implicit measures, as everyone seems to use that term. So the official line I was told by MS is there are no implicit measures in PBI, just implicit calculations. The difference is transparent to the user, but technically there is no implicit measure in PBI, but there is in Power Pivot. There is no actual measure generated, but the use of the Columns in this way causes the tool (PBI) to generate the aggregations automatically under the hood. The software has a set of standard functions (sum, count, min, max, etc) that it allows the user to apply to a column when used in a visual (in some locations). PBI handles it differently, more like a regular pivot table (without Power Pivot). If you do this in PP, then migrate the model to PBI, you can actually see the implicit measure, DAX and all. In Power Pivot, there is actually a measure generated and stored in the Power Pivot model (implicit measure). There is a technical difference to the way Power Pivot handles this, and the way it is done in PBI. I have actually spoken to MS about this, Will Thompson and Kasper de Jonge, from memory. ![]() Yes, you can learn yourself using YouTube – there is a lot of great free content out there (like my video below), but you will learn better/faster if you take a structured course built by industry professionals. If you would like to learn more about Power BI from experts like me, Ken Puls, Miguel Escobar, and Reid Havens (all Microsoft MVPs), head over to and check out our training course catalogue. You can see in the image below, the user can select a year from the top slicer and any other year from the bottom slicer, and the visual updates along with the title of the visual clearly communicating what is being displayed. Check out my video below to see how I did it. What is possible is endless, and the good news is that it is pretty simple to do this in Power BI. Snapshots (eg different versions of a financial forecast) with any other version.Any product against any other product (maybe even a group of products, using multi select).The whole concept here is to allow a user to pick two things from a list and compare them with each other. Some concepts are best documented (traditional blogging) and some are just easier for everyone if it is a video. I have been increasingly recording videos as my method of sharing tips and techniques for getting more out of Power BI. Relationships in Power BI and Power Pivot.Who Needs Power Pivot, Power Query and Power BI Anyway?.The Best Way to Install Power BI Desktop.30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Power BI for the Business Analyst (with live Q&A).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |