The earlier put up defined what Skinny experiences are, why we must always care and the way we are able to create them. This put up focuses on a extra particular subject, Report Stage Measures. We focus on what report-level measures are, when and why we want them and the way we create them.
If you’re undecided what Skinny Report means, I recommend you try my earlier weblog put up earlier than studying this one.
What are report stage measures?
Report stage measures are the measures created by the report writers inside a Skinny Report. Therefore, the report stage measures can be found inside the internet hosting Skinny Report solely which implies the report stage measures are usually not written again to the underlying dataset and therefore they aren’t accessible to every other experiences.
Why and when do we want report stage measures?
It’s a widespread scenario in real-world situations when the enterprise requires a report urgently, however the nuts and bolts of the report are usually not being created on the underlying dataset but. For example, the enterprise requires to current a report back to the board exhibiting 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 underneath the pump to ship another functionalities which including a brand new measure is just not even of their venture supply plan. It’s maybe too late if we anticipate the builders to plan for creating the required measure, undergo the discharge course of, and make it accessible for us within the dataset. Right here is when the report stage measures come to the rescue. We are able to 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 stage measures?
At present, we are able to create report stage measures solely in Energy BI Desktop when Join Stay to both a Energy BI dataset, an SSAS Tabular mannequin (on-premises), or Azure Evaluation Providers (AAS). For this weblog put up, 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 Residence tab
- Click on the Energy BI datasets
- Choose the specified dataset
- Click on Join
- Proper-click the desk that you just’d wish to host the report stage measure and choose New measure
- Kind your DAX expressions as regular 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 simply accessible within the present report and never on the dataset stage and that’s the reason the sort of measure is the so-called Report Stage Measure. All different measures are dataset stage measures, subsequently, they’re accessible on the present report and every other skinny experiences we create sooner or later on high of the identical dataset.
We are able to now use the Avg Unit Value as regular in our knowledge visualisation.
As maybe have observed already, we are able to additionally create report stage measures utilizing the Fast Measures functionality.
As a facet be aware, you too can see the underlying knowledge 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 might like to know your ideas, so be at liberty to depart your feedback beneath.