Complex Filter Conditions In Power BI Reports Using Visual-Level Filters And Measures

While Power BI has a lot of great functionality for filtering the data that appears in a visual using visual-level filters there are going to be situations where you need more control over how filtering works, and in this blog post I’m going to show you how you can use visual-level filters and measures in combination to achieve this. The example I show here may be quite specific but I think the general technique has a lot of other interesting applications.

Bron : Chris Webb’s BI Blog
Lees meer…

DAX Functions, DirectQuery And Unrestricted Measures

If you use Power BI to connect to a data source such as SQL Server in DirectQuery mode, you’ll find that by default you cannot use the complete range of DAX functions inside your calculations. For example, here’s a screenshot from Power BI Desktop in DirectQuery mode with a measure where I’m trying to use the RankX() function:

Bron : Chris Webb’s BI Blog
Lees meer…

Considerations for Setting Up Base Unit of Measure in Dynamics NAV

Microsoft Dynamics NAV is very flexible when it comes to setting up Units of Measure for items. But careful consideration should be used before setting up the Base Unit of Measure. Once the Base Unit of Measure is established and there are transactions recorded for the item, the Base Unit of Measure cannot be changed.

Bron : ArcherPoint
Lees meer…

Using Microsoft Dynamics NAV Work Center Units of Measure (other than Time Units)

It is quite common in processing industries, like chemical production, that the cost of Labor is not the primary cost of production. In chemical processing, the cost of energy or depreciation may be the largest cost component.

While Centers and Routings in Dynamics NAV are typically thought of in terms of Direct Cost (Labor) and Overhead, we can set up Work Centers and Routings to accommodate other cost components.

Bron : ArcherPoint
Lees meer…