Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
i want examples of these points ..
any example please?
Solved! Go to Solution.
So, an example of the first one, to get to an individual value of a cell you could do something like this:
Measure = MAXX(FILTER('Table',[Column] = "Something"),[Value])
This would filter the table "Table" to only the rows where "Column" equals the value "Something" and then return the maximum value in the Value column from that subset. Note, there are literally tens of thousands if not hundreds of thousands of examples that could be provided for this because it is how DAX works. It is a core concept and I include it in my book in the first chapter "Thinking DAX".
Correct, this would be a calculated column like:
New Column = [Column1] + [Column2]
Each row would take the value in Column1 and Column2 for that row and add them together into the new column, "New Column".
Or, in a measure, you can use ADDCOLUMNS and it's the same sort of thing.
Hi @Bakhtawar ,
Here is the test data.
Then I created a measure:
Measure =
SUM('Table'[Column3])
Now you could do see the different results with column1 and column2.
The measure will show different result depends on your context.
So, an example of the first one, to get to an individual value of a cell you could do something like this:
Measure = MAXX(FILTER('Table',[Column] = "Something"),[Value])
This would filter the table "Table" to only the rows where "Column" equals the value "Something" and then return the maximum value in the Value column from that subset. Note, there are literally tens of thousands if not hundreds of thousands of examples that could be provided for this because it is how DAX works. It is a core concept and I include it in my book in the first chapter "Thinking DAX".
Correct, this would be a calculated column like:
New Column = [Column1] + [Column2]
Each row would take the value in Column1 and Column2 for that row and add them together into the new column, "New Column".
Or, in a measure, you can use ADDCOLUMNS and it's the same sort of thing.
and second one ?
Hi @Bakhtawar ,
Here is the test data.
Then I created a measure:
Measure =
SUM('Table'[Column3])
Now you could do see the different results with column1 and column2.
The measure will show different result depends on your context.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |