Thank you for resourceful content I would like to ask, can we use ADDCOLUMNS to segment the data dynamically as long as It accepts the filter context ?
Very useful feature. It would be really good if Microsoft enable creating new column in live connection, without having to convert the model to DirectQuery.
Hello, you make great videos, thanks for the knowledge, can you please tell me what is the make and model of your chair ? it looks very comfortable, Thank you
Power BI generates DAX queries, you can test these queries in DAX Studio or you can create new queries for Paginated Reports or other clients (also Excel, for example).
Hi Alberto, thank you for your great video. Do you know of examples where it would be better to use Define Column instead of Addcolumn? For me, it seems that I can do pretty much anything already with AddColumns. I'm just curious. Thank you!
So far I have not found a query that cannot be expressed without DEFINE COLUMN. From a syntactical point of view, they are awesome and make the code very readable. But I don't think they actually increase the power of the language. I will publish a video about a comparison between query columns and ADDCOLUMNS, stay tuned!
In theory, after. In practice, RLS is still not fully implemented in composite models, but this is the way it should work (otherwise, it would be an enormous security hole...).
@@SQLBI Correct me if I'm wrong. In the import model, the calculated columns takes place at refresh time, right? And RLS is implemented at "DAX Query" time after the calculated column is being computed... So, depending on how the calculated column expression is constructed, the order may change the result. If the order on Direct query is the inverse, this may end um showing unexpected results.
Indeed, the behavior is not (and cannot be) the same. The query calculated column cannot bypass the security. It is computed before the query is executed but within the security perimeter. If this was not true, it would be a way to access secure data without proper authorization.
@@SQLBI Apologize for the confusion. Rephrasing the question.. What happens if we use Summarizecolumns( Customer[Gender], //instead of product [color] Customer [IsLarge], ... )
In the case of the query column, it is still evaluated by customer regardless of the color. Every customer has a gender value, so you would see the aggregation of the customer with that value.
@@SQLBI thank you. Is there a way of finding a subtotal row in matrix visual? Issubtotal can only be used in summarise but i want to use issubtotal in a measure - ex: issubtotal ( level1,level2) to return true. Is there a way to achieve this?
Best teacher ever
Thank you for resourceful content
I would like to ask, can we use ADDCOLUMNS to segment the data dynamically as long as It accepts the filter context ?
Very useful feature. It would be really good if Microsoft enable creating new column in live connection, without having to convert the model to DirectQuery.
Hello,
you make great videos, thanks for the knowledge,
can you please tell me what is the make and model of your chair ?
it looks very comfortable,
Thank you
It is! :) Herman Miller Aeron (with an additional headrest found on Amazon; for whatever reason the original chair is missing the head support)
Probably an obvious answer but are query's able to be used in any way with Power BI? Aside from running free form queries in Dax Studio?
Power BI generates DAX queries, you can test these queries in DAX Studio or you can create new queries for Paginated Reports or other clients (also Excel, for example).
Hi Alberto, thank you for your great video. Do you know of examples where it would be better to use Define Column instead of Addcolumn?
For me, it seems that I can do pretty much anything already with AddColumns.
I'm just curious. Thank you!
So far I have not found a query that cannot be expressed without DEFINE COLUMN. From a syntactical point of view, they are awesome and make the code very readable. But I don't think they actually increase the power of the language. I will publish a video about a comparison between query columns and ADDCOLUMNS, stay tuned!
Excellent! As always...
Does DEFINE COLUMN takes place before or after RLS is applied?
In theory, after. In practice, RLS is still not fully implemented in composite models, but this is the way it should work (otherwise, it would be an enormous security hole...).
@@SQLBI Correct me if I'm wrong. In the import model, the calculated columns takes place at refresh time, right? And RLS is implemented at "DAX Query" time after the calculated column is being computed... So, depending on how the calculated column expression is constructed, the order may change the result.
If the order on Direct query is the inverse, this may end um showing unexpected results.
Indeed, the behavior is not (and cannot be) the same. The query calculated column cannot bypass the security. It is computed before the query is executed but within the security perimeter. If this was not true, it would be a way to access secure data without proper authorization.
Thank you for the video! I have a challenge for you - is it possible to use the PATH function in a measure using DEFINE COLUMN or another approach?
Yes you can!
@@SQLBI Thank you, I am going to give it another try! Would be huge for my HR model if I could leverage PATH more ways than a calculated column.
Whoa! I got it to work! Now I need to figure out how to use the query in a measure. This video sparked a new area of exploration for me. Thank you!
Hello, is there a way to write a DAX query statement with a measure that consist of a new calculated column?
You can use that column in a DAX query statement, including in query measures.
Nice.. thank you. If it wasn't grouped by product color, instead any other column from customer table, then it would give correct results ?
If you relate to the Customer[IsLarge] column, it would be always computed for each customer, so the grouping column in the query doesn't matter.
@@SQLBI okay that's great, instead of Customer [IsLarge], what if we use Customer [Gender] for example..
Sorry we don't understand the question. IsLarge is the calculated column created in the query. Please, can you clarify what you mean?
@@SQLBI Apologize for the confusion. Rephrasing the question..
What happens if we use
Summarizecolumns(
Customer[Gender], //instead of product [color]
Customer [IsLarge],
...
)
In the case of the query column, it is still evaluated by customer regardless of the color. Every customer has a gender value, so you would see the aggregation of the customer with that value.
Is there a way to replace default subtotals with precalculated subtotal rows in matrix?
You should write a measure that depending on the filter context produces different results. See this: www.daxpatterns.com/hierarchies/
@@SQLBI thank you. Is there a way of finding a subtotal row in matrix visual? Issubtotal can only be used in summarise but i want to use issubtotal in a measure - ex: issubtotal ( level1,level2) to return true. Is there a way to achieve this?
ISINSCOPE described in the article, but you are not able to know whether the level is used as subtotal or not.
Molto ben spiegato.
Thanks.
Excellent!谢谢
Nice feature
Graziè
almost the first viewer, almost.. next time :) heh