Measures Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/measures/ Bestselling Excel and Power BI Courses Tue, 25 Apr 2023 14:02:30 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Measures Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/measures/ 32 32 How to Do Many-to-One Side Calculations in Data Models with DAX https://www.xelplus.com/dax-many-to-one-side-calculations/ Thu, 10 Mar 2022 10:00:00 +0000 https://www.xelplus.com/?p=9406 In Power BI or Power Pivot, you often need to create reports that go from the many side of the relationship to the one side. How can you do that without expanding your data model by adding more columns to your table? There is an easy trick you can use to solve this with a single DAX formula. Of course, the formula uses the CALCULATE function.

The post How to Do Many-to-One Side Calculations in Data Models with DAX appeared first on Xelplus - Leila Gharani.

]]> 10 Power BI Tips & Tricks https://www.xelplus.com/power-bi-tips-tricks/ Thu, 03 Feb 2022 10:00:00 +0000 https://www.xelplus.com/?p=9491 Power BI can do THAT? Learn 10 quick tips to enhance your Power BI dashboards: Conditionally format charts, create a separate measures table, customize your own tool tips and a lot more.

The post 10 Power BI Tips & Tricks appeared first on Xelplus - Leila Gharani.

]]> DAX CALCULATE Function Made Easy to Understand https://www.xelplus.com/dax-calculate-function/ Thu, 09 Dec 2021 10:00:00 +0000 https://www.xelplus.com/?p=1491 If you'd like to "see" how the DAX CALCULATE function works, then you need this tutorial. It will show you how the CALCULATE function works and delivers results.

The post DAX CALCULATE Function Made Easy to Understand appeared first on Xelplus - Leila Gharani.

]]> 3 Hidden Tips for Excel Power Pivot https://www.xelplus.com/3-hidden-tips-for-power-pivot/ Tue, 30 Nov 2021 08:17:00 +0000 https://www.xelplus.com/?p=9707 These 3 hidden Excel Power Pivot tips will help you to: Copy your data model from one file to another, create a dedicated measures table and convert your pivot table data to formulas.

The post 3 Hidden Tips for Excel Power Pivot appeared first on Xelplus - Leila Gharani.

]]> How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick https://www.xelplus.com/excel-interactive-dashboard-trick-dax/ Thu, 09 Sep 2021 08:43:00 +0000 https://www.xelplus.com/?p=9812 With Pivot Charts in Microsoft Excel, you can add slicers to add interactive functionality to your dashboards. But what about adding even more interactivity? You could give the user the ability to change the relevant KPI in the chart from the slicer. You just need a tiny bit of DAX.

The post How to Include Measures (or KPIs) inside Slicers – Excel Interactive Dashboard Trick appeared first on Xelplus - Leila Gharani.

]]>