Bill Pearson


Stairway to DAX and Power BI - Level 16: The DAX ALLEXCEPT() Function

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLEXCEPT() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLEXCEPT(), focusing largely upon its most popular use in removing filters from all columns in a table - except the filters we specify.

2020-10-14

1,050 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 13: Simple Context Manipulation: Introducing the DAX All() Function

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX All() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to All(), focusing largely upon its most basic uses in manipulating filter context.

5 (1)

2020-09-23 (first published: )

3,501 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 15: The DAX ALLSELECTED() Function

Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX ALLSELECTED() function, discussing its syntax, uses and operation. He then provides hands-on exposure to ALLSELECTED(), focusing largely upon its most popular use in supporting “visual totals” in Power BI.

4 (2)

2020-09-02

1,236 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 14: DAX CALCULATE() Function: The Basics

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CALCULATE() function, discussing its syntax, basic uses and operation. He then provides hands-on exposure to CALCULATE(), focusing largely upon its most basic uses in evaluating an expression in a context that is modified by specified filters.

5 (1)

2020-08-12

1,594 reads

Stairway to MDX

Stairway to MDX - Level 5: Members, and an Introduction to the MDX Members Functions

Bill explains what is meant by a 'Member' and 'Member function' in MDX. A member is an item in a dimension that include the 'measures' which are the values of the attributes that belong to a dimension. 'Measures' are themselves members of a dimension called the “measures” dimension. MDX has a set of functions, known as member functions, each of which allow us to perform operations upon any member of a dimension

2018-01-17 (first published: )

8,811 reads

Stairway to DAX and Power BI

Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions

Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.

5 (1)

2017-11-29

3,354 reads

Blogs

Requesting Comments on the SQLOrlando Operations Manual

By

For the past couple weeks I’ve been trying to capture a lot of ideas...

Ignoring Comments in SQL Compare

By

Recently I had a client that wanted to know how they could use SQL...

PASS SQLSaturday’s I will be speaking at

By

I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that...

Read the latest Blogs

Forums

vipcontentonline

By vipcontentonline

a hit freelancers swear by exercises — washing your face, putting on real garments...

Rules in PostgreSQL

By sabyda

Comments posted to this topic are about the item Rules in PostgreSQL

Ordering with NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering with NULL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers