Stairway Series

Stairway to DAX and Power BI

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

  • Stairway Step

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)

You rated this post out of 5. Change rating

2020-09-02

3,875 reads

Stairway to DAX and Power BI

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

  • Stairway Step

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2020-08-12

7,988 reads

Stairway to U-SQL icon

Stairway to U-SQL Level 22: Creating a Custom Extractor

  • Stairway Step

Throughout this series, we’ve consistently dealt with delimited text files; comma and tab, for instance. We’ve used the U-SQL built-in extractors to process these files. But what if we need to deal with different types of file, like JSON, XML or fixed width? That’s where custom extractors come in. U-SQL provides us with the ability […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-07-01

1,622 reads

Stairway to TDE icon

Restore a Backup of a TDE Database to Another Server: Level 2 of the Stairway to TDE

  • Stairway Step

In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2026-04-15 (first published: )

55,858 reads

Stairway to TDE icon

Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE

  • Stairway Step

The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2026-04-15 (first published: )

12,289 reads

Blogs

Installing and Configuring containerd as a Kubernetes Container Runtime

By

This post shows you how to install containerd as the container runtime for Kubernetes...

It’s 2026 and I’m retired, so lets get Visual Basic 6.0 to run on Windows 11

By

In 1999 I released my first commercial software product. ShutOff 2000 was a Windows...

Car Update October 2026

By

This month I want to look at a few of the things I’ve seen...

Read the latest Blogs

Forums

Alamat Telp BCA KCP Bungur +62 838-4945-0961

By layanan 24jam BCA

Wa:083849450961 Jl. Bungur Besar Raya No.32 & 32A, RT.3/RW.1, Gn. Sahari Sel., Kec. Kemayoran,...

BCA KCP Citra Garden +62 838-4945-0961

By m4l4mt194

Wa:083849450961 Perum. Citra Garden I Blok I.1/4, RT.9/RW.16, Kalideres, Kec. Kalideres, Kota Jakarta Barat,...

PostgreSQL 19 Is Late

By Steve Jones - SSC Editor

Comments posted to this topic are about the item PostgreSQL 19 Is Late

Visit the forum

Question of the Day

Hyperscale Replicas V

I have an Azure SQL Database Hyperscale Edition system running with a geo-replica enabled. Can I create a new geo-replica based on the current secondary geo-replica?

See possible answers