how to use the quick analysis button to sum the range

Save the changes and close the Tabular Editor.Īs shown below, we can create a calculation group through the Tabular Editor to solve the issue of data format of switch measure. We use this measure to dynamically select calculation items based on slicer. The final step is to create measure for the calculation group. Using DAX to write the calculation item and set the string format. Right click calculation items and create a new one. In calculation group, create a new calculated item. Right click the table, select create new, and then click calculation group. If you don't see these menu options in power bi desktop, you need to load the Tabular Editor first. Under external tools, select Tabular Editor. Power Bi announced in July 2020 that public preview of external tool support in Power BI Desktop. Below, I will show how to use the Tabular Editor to dynamically switch the measure. Now we can use the Tabular Editor to achieve this. The switch measure can only have one data type. Measure = SWITCH(SELECTEDVALUE('Table (2)'),Īs shown in the picture, this is the limitation of this method. Return DIVIDE(per_product,total_month_salesĬreate a disconnected table with the measure name and create a switch measure. In the previous method, we usually created a disconnected table as a slicer, and then created a switch measure to show the result.ĪLLEXCEPT('Table','Table','Table'.)) Since all measures are encapsulated in a switch measure, only one data type is allowed.įor example, we want to dynamically display the rate of product sales in the current month or product sales. However, this method has the limitation of data format.

Create several measures and create a disconnected table to use as slicer. I've always done this before about using slicers to display different measures in graph. How to use a slicer to show different measures? This article will show you another way to create dynamic charts based on the external tools (Tabular Editor) updated in July 2020.

How to use the quick analysis button to sum the range