Elements of DAX 02-02: Summary Query Concepts

preview_player
Показать описание
In this video, Brian Grant helps you get how Summary Queries are structured and how that produces the results you need in Power BI. You'll understand their different sections and see how to go from the Power BI user interface to a drawn visual.

------------
Don't forget to subscribe to our channel for the latest Power BI, Power Platform, Azure, and Data Analytics content.

At CSG Pro, we love learning and sharing new technologies, processes, and solutions to help you be victorious in your role.

Work with us:

Visit our blog:
  1. Skypoint
  2. Power BI
  3. Brian Grant
  4. Elements of DAX
  5. Power BI DAX
  6. DAX
Рекомендации по теме
Elements of DAX 0:08:20

Elements of DAX 02-02: Summary Query Concepts

Elements of DAX 0:19:14

Elements of DAX 02-04: Summary Query to Summary Table Example

Elements of DAX 0:00:54

Elements of DAX 02-00: Summary Query Chapter Introduction

Elements of DAX 0:06:58

Elements of DAX 02-03: Summary Query Parts Matching

Elements of DAX 0:04:12

Elements of DAX 02-01: Review of the Elements Chapter's Data Models

Elements of DAX 0:10:31

Elements of DAX 06-02: Filter Type Concepts

Elements of DAX 0:10:01

Elements of DAX 04-02: The PT (PhysicalTable) Derivation

Elements of DAX 0:07:50

Elements of DAX 05-02: Derive Iterate Application - VALUES()

Elements of DAX 0:30:33

Elements of DAX 01-02: What is a Measure?

Elements of DAX 0:07:13

Elements of DAX 04-01: Table Derivation Concepts

Elements of DAX 0:06:43

Elements of DAX with Brian Grant — Series Preview

Elements of DAX 0:15:38

Elements of DAX 01-01: What is DAX?

Elements of DAX 0:11:17

Elements of DAX 06-01: Filter Reviser Concepts

Elements of DAX 0:08:40

Elements of DAX 03-01: Iterator Concepts

Elements of DAX 0:21:30

Elements of DAX 03-02: The Aggregation Iterators (A)

Elements of DAX 0:07:12

Elements of DAX 06-04: Override Filter Concepts

Elements of DAX 0:11:56

Elements of DAX 03-05: SUMX() vs SUM()

Elements of DAX 0:13:56

Elements of DAX 00-01: An Introduction to the Framework

Elements of DAX 0:00:34

Elements of DAX 01-00: Basic Concepts Chapter Introduction

Elements of DAX 0:00:56

Elements of DAX 06-00: Filter Revisers (Pt1) Chapter Introduction

Elements of DAX 0:08:17

Elements of DAX 05-03: Derive Iterate Application - ALL()

Elements of DAX 0:00:52

Elements of DAX 04-00: Table Derivations Chapter Introduction

Elements of DAX 0:17:21

Elements of DAX 05-01: Derive Iterate Application - PT

Elements of DAX 0:03:26

Elements of DAX 99-00: Preview of Upcoming Chapters

Комментарии
Автор

Thanks Brian for sharing your efforts and hardwork. Clearly there's so much time and effort involved in designing the course and the presentation layout.

khardu
Автор

I am experimenting with DAX Studio and running into an issue with the external filter written like this "Mini[Dish] IN { "Burger", "Salad"}. All the other filter lines work (commented out). From the error message, it looks like there is no row context. Any thoughts? Thanks.

EVALUATE
SUMMARIZECOLUMNS(
Mini[Dish],
Mini[Type],
--FILTER(Mini, Mini[Dish] = "Pasta"),
--FILTER( ALL(Mini[Dish]), Mini[Dish] = "Pasta"),
--FILTER( ALL(Mini[Dish]), Mini[Dish] IN {"Burger", "Salad"}),
--FILTER( ALL(Mini[Dish]), Mini[Dish] IN {"Burger", "Pasta"}),
--TREATAS ( {"Burger", "Pasta"}, Mini[Dish] ),
--Mini[Dish] IN {"Burger", "Pasta"},

"Total Units", [Total Units]
)

retamapark
Автор

This is the error message "Query (10, 2) A single value for column 'Dish' in table 'Mini' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

retamapark