The earlier submit defined what Skinny studies are, why we must always care and the way we are able to create them. This submit focuses on a extra particular matter, Report Stage Measures. We talk about what report-level measures are, when and why we’d like them and the way we create them.
In case you are undecided what Skinny Report means, I counsel you try my earlier weblog submit earlier than studying this one.
What are report degree measures?
Report degree measures are the measures created by the report writers inside a Skinny Report. Therefore, the report degree measures can be found inside the internet hosting Skinny Report solely which implies the report degree measures aren’t written again to the underlying dataset and therefore they don’t seem to be obtainable to another studies.
Why and when do we’d like report degree measures?
It’s a frequent state of affairs in real-world situations when the enterprise requires a report urgently, however the nuts and bolts of the report aren’t being created on the underlying dataset but. For example, the enterprise requires to current a report back to the board displaying year-to-date gross sales evaluation however the year-to-date gross sales measure hasn’t been created within the dataset but. The enterprise analyst approaches the Energy BI builders so as to add the measure, however they’re below the pump to ship another functionalities which including a brand new measure shouldn’t be even of their challenge supply plan. It’s maybe too late if we await the builders to plan for creating the required measure, undergo the discharge course of, and make it obtainable for us within the dataset. Right here is when the report degree measures come to the rescue. We will merely create the lacking measure within the Skinny Report itself, the place we are able to later share it with the builders to implement it as a dataset measure.
How will we create report degree measures?
At present, we are able to create report degree measures solely in Energy BI Desktop when Join Stay to both a Energy BI dataset, an SSAS Tabular mannequin (on-premises), or Azure Evaluation Companies (AAS). For this weblog submit, I Join Stay to a Energy BI dataset. Open Energy BI Desktop first and observe these steps.
- Click on the Information hub dropdown button from the House tab
- Click on the Energy BI datasets
- Choose the specified dataset
- Click on Join
- Proper-click the desk that you simply’d prefer to host the report degree measure and choose New measure
- Kind your DAX expressions as ordinary and press enter
A brand new measure (Avg Unit Value) is now created on the Web Gross sales desk. As defined earlier, the brand new measure is just obtainable within the present report and never on the dataset degree and that’s the reason this kind of measure is the so-called Report Stage Measure. All different measures are dataset degree measures, due to this fact, they’re obtainable on the present report and another skinny studies we create sooner or later on high of the identical dataset.
We will now use the Avg Unit Value as ordinary in our information visualisation.
As maybe have observed already, we are able to additionally create report degree measures utilizing the Fast Measures functionality.
As a aspect notice, you too can see the underlying information mannequin by clicking the Mannequin view tab as proven within the following picture:
Have you ever used this functionality? What challenges have you ever confronted in utilizing Report Stage Measures? I’d like to know your ideas, so be happy to go away your feedback beneath.