This part of Measure Killer gives you unique insights into what is used in the:

-Semantic model

-Reports

-Pages

-Visuals

​

As you first open What if analysis, you will have multiple modes to select. We will be explaining each one of them in the following sections.

​​​

​​

​

​

​

​

​

 

 

What if analysis​ mode selection.

​

"Full view" mode:

​

 

 

 

 

 

 

 

 

 

 

What if analysis​ "Full view" mode.

​

The "Full View" mode displays the hierarchy of dependencies between elements, starting from your model and report down to columns and measures. It enables you to see every measure and column used in a visual, as well as the columns referenced by those measures and so on. By searching for a column or measure name, you can quickly find all the places where it is used, directly or indirectly, within your report or model.​​​​​​​​​​​​​​

​​​

"Report" mode:

​

 

 

 

 

 

 

 

 

 

 

What if analysis​ "Report" mode.

 

Whether you have one or multiple reports connected to a model, this mode allows you to see how much of the model each report uses and what portions are exclusive to a single report (Potential savings column). This information helps you understand the importance of different parts of your model to your reports and determine how much of the model could be removed if a report is deleted.

​​​

The Potential Savings column appears in every mode of What if analysis and indicates how much space (in percentage or raw size) can be saved by removing a specific element. It considers all the columns the element relies on, including those used by measures or other columns used by this element. This feature helps you understand the impact of removing an element and how much it could reduce your model's size.

​​

In the image above, we can see that the "Get data paginated" report is exclusively using 5,15% of the model. This means that removing this report could save this amount (5,15%) from the size of our model. This number is calculated by summing the size of all columns only used by this report.

​

"Page" mode:

​​

​

​

​

​

​

 

 

 

 

 

 

 

 

 

 

What if analysis​ "Page" mode.​

​

The "Page" mode is similar to the "Report" mode, but instead of listing reports, it displays all pages within them. This mode allows you to see all columns and measures used by each page.

​​

"Visual" mode:

​

​​​

​

​

​

​

​

 

What if analysis​ "Visual" mode.

 

The same logic applies for the visual mode. This can be used to remove specific visuals to save model space.

​

"Measure" mode:

 

​

​

​

​

​

​

What if analysis​ "Measure" mode.

​

For measures, we approximate a "size" based on the total size of all columns the measure relies on. This estimation is only used to gauge the percentage of data accessed by the measure.