In this video, we are going to see how to regroup different measures inside one measure and call different calculations based on slicer selection. This is a must know in BI solutions!
We are going use SWITCH function with two approaches and we will also see some other DAX functions like DATATABLE, VALUES and SELECTEDVALUE.
0:00 Introduction
1:24 Create a table using DATATABLE
4:10 Switch function method 1 - VALUES
7:24 Switch function method 2 - SELECTEDVALUE
9:15 Visual Formatting
13:20 Sort a column by another column
Негізгі бет Different Measures Based on Slicer Selection in Power BI
No video
Пікірлер: 43