Different Calculations Based on Hierarchy Levels Inside One Measure in Power BI

Описание к видео Different Calculations Based on Hierarchy Levels Inside One Measure in Power BI

In this video, we are going to see how to have one measure that calculates differently based on the hierarchy level in an effective way.
This is a must know technique and we face this kind of requirements in the real BI projects constantly.
We are going to see how to use the combination of the following DAX functions:
IF(ISFILTERED…
IF(NOT(ISBLANK…
IF(NOT(HASONEFILTER…

0:00 Introduction
2:07 Calculate percentage over hierarchy
4:10 Different calculations based on hierarchy level
7:05 Format inside DAX measure
8:17 Remove lines without values using DAX
11:35 Detect & calculate total line inside DAX

Комментарии

Информация по комментариям в разработке