Wednesday, October 5, 2022
HomeBusiness IntelligenceSkinny Studies, Report Stage Measures vs Knowledge Mannequin Measures

Skinny Studies, Report Stage Measures vs Knowledge Mannequin Measures


Thin Reports, Report Level Measures vs Data Model Measures

The earlier put up defined what Skinny studies are, why we should 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.

In case you are undecided what Skinny Report means, I counsel you try my earlier weblog put up 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 throughout the internet hosting Skinny Report solely which implies the report degree measures aren’t written again to the underlying dataset and therefore they aren’t out there to every other studies.

Why and when do we want report degree measures?

It’s a frequent state of affairs in real-world eventualities when the enterprise requires a report urgently, however the nuts and bolts of the report aren’t being created on the underlying dataset but. As an 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 will not be even of their mission supply plan. It’s maybe too late if we look ahead to the builders to plan for creating the required measure, undergo the discharge course of, and make it out there for us within the dataset. Right here is when the report degree 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 can we create report degree measures?

At the moment, we are able to create report degree measures solely in Energy BI Desktop when Join Dwell to both a Energy BI dataset, an SSAS Tabular mannequin (on-premises), or Azure Evaluation Providers (AAS). For this weblog put up, I Join Dwell to a Energy BI dataset. Open Energy BI Desktop first and comply with these steps.

  1. Click on the Knowledge hub dropdown button from the Dwelling tab
  2. Click on the Energy BI datasets
  3. Choose the specified dataset
  4. Click on Join
Connecting Live to a Power BI dataset from Power BI Desktop
Connecting Dwell to a Energy BI dataset from Energy BI Desktop
  1. Proper-click the desk that you just’d wish to host the report degree measure and choose New measure
Creating a new report level measure in Power BI Desktop
Creating a brand new report degree measure in Energy BI Desktop
  1. Kind your DAX expressions as ordinary and press enter
Typing DAX expressions to create report level measures
Typing DAX expressions to create report degree measures

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 out there within the present report and never on the dataset degree and that’s the reason this sort of measure is the so-called Report Stage Measure. All different measures are dataset degree measures, due to this fact, they’re out there on the present report and every other skinny studies we create sooner or later on high of the identical dataset.

We are able to now use the Avg Unit Value as ordinary in our knowledge visualisation.

Using report level measures in visuals in Power BI Desktop
Utilizing report degree measures in visuals in Energy BI Desktop

As maybe have observed already, we are able to additionally create report degree measures utilizing the Fast Measures functionality.

As a aspect word, you can too see the underlying knowledge mannequin by clicking the Mannequin view tab as proven within the following picture:

Model view tab in Power BI Desktop when connected live to a Power BI dataset
Mannequin view tab in Energy BI Desktop when linked stay to a Energy BI dataset

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 depart your feedback under.

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments