test-post
Musings from developing and deploying enterprise grade semantic models – Part 3: Technical learnings
In Part 1 of this series we introduced the concept of enterprise grade semantic models and in Part 2 we discussed some general learnings from developing and deploying enterprise grade semantic models. In Part 3 we will discuss the technical learnings. You won't find a...
Musings from developing and deploying enterprise grade semantic models – Part 2: General learnings
In Part 1 of this series, I gave a brief introduction to the concept of semantic models and why they should be designed. In this article I discuss the general learnings from developing and deploying semantic models If you are doing it all by yourself, it is not...
Musings from developing and deploying enterprise grade semantic models – Part 1: Introduction
For the past one year, I have been fortunate enough to work on a digital transformation project for one of Australia's largest superannuation funds to develop enterprise grade semantic models. I worked with a wonderful team comprising Solution Architects, Information...
How to solve business problems using DAX – Part 5: What is Australia’s share of global export coal revenue ?
0In Part 4 of the series, we talked about how to solve business problems when you want to filter a measure using numeric and date expressions. In this series, we go to the next level of business problems where we discuss problems involving % of the total. These kind...
How to solve business problems using DAX – Part 4: How many sales orders are greater than $3000
In Part 3 of the series, we talked about how to solve business problems when you want to filter a measure by attributes from the fact/dimension table and then evaluate an expression. In this series, we continue the conversation and this time we talk about how to...
The eleven rules of DAX management
There are several articles and books written on how to write better DAX and I have written a fair few as well. This article is not one of them. What will cover in this article are some of the best practices associated with DAX management and housekeeping before we...
How to solve business problems using DAX – Part 3: What is the sales amount for the Contoso Brand ?
In the second part of the series on how to solve business problems using DAX we looked at some patterns for calculating averages different grains in the model. In this series we will look at patterns where we need sales amount filtered for a value(s) of an column of...
How to solve business problems using DAX – Part 2: What is the average sales amount by store ?
In Part 1 of the series, we looked at some patterns to solve business problems which involved calculating total sales, maximum discount, unique products sold etc. In this Part, we will look at some patterns which involve calculating averages and also discuss some...
How to solve business problems using DAX – Part 1: What is the total/max/min sales amount
Welcome to the first part of the series on "How to solve problems using DAX". I spent a lot of time last year posting DAX challenges on LinkedIn which not only covered DAX functions such as CALCULATE, FILTER, TOPN, RANKX but also concepts such as context transition...
Visualising top city sales % for a region
This post is inspired by a blog in which the author showcased the visualisation of % top city sales for a region in Tableau. I thought the solution provided was cumbersome so decided to visualise it in Power BI. It turns out that the DAX for this is straightforward...