How does the ALLSELECTED function (DAX) work? The ALLSELECTED function (DAX) returns all the rows in a table or all the values in a column, while ignoring any filters that might have been applied inside the query, while keeping any filters that came from the outsid...

How does the SELECTEDVALUE function (DAX) work? The SELECTEDVALUE function (DAX) returns Returns the value when the context for columnName has been filtered down to one distinct value only. Otherwise returns alternateResult. SELECTEDVALUE Formula Syntax SELECTEDVAL...

How does the EXCEPT function (DAX) work? The EXCEPT function (DAX) returns the rows of one table which do not appear in another table. EXCEPT Formula Syntax EXCEPT ( <table_expression1> <table_expression2>) How do you use the EXCEPT f...

How does the ISINSCOPE function (DAX) work? ISINSCOPE function (DAX) returns true when the given column is the level within a level hierarchy. ISINSCOPE Formula Syntax How do you use the ISINSCOPE function? It returns TRUE if the column is included in the filter co...

How does the INT function (DAX) work? INT function (DAX) rounds a number down to the nearest integer. INT Formula Syntax How do you use the INT function? INT performs a type conversion to integer and always returns an integer, whereas other rounding functions (such...

How does the IN Operator / CONTAINSROW function (DAX) work? IN Operator / CONTAINSROW function (DAX) returns TRUE if a value row exists or is included in a table, otherwise FALSE returns. Except for syntax, the IN operator and CONTAINSROW function are functionally ...

How does the IN function (DAX) work? IN function (DAX) returns True if the scalar value shows up in at least one row of the input relation. IN Formula Syntax How do you use the IN function? The IN operator can be used also with dynamic expressions, and it can compa...

How does the IFERROR function (DAX) work? IFERROR function (DAX) evaluates an expression and returns a specified value, if the expression returns an error; otherwise returns the value of the expression itself. IFERROR Formula Syntax How do you use the IFERROR funct...

How does the IF function (DAX) work? IF function (DAX) checks whether a condition is satisfied as the first statement. It returns one value if the condition is TRUE, and if the condition is FALSE returns another value. IF Formula Syntax How do you use the IF functi...

How does the HASONEVALUE function (DAX) work? Returns TRUE if only one distinct value has been filtered to the context for columnName. Otherwise, it is FALSE. HASONEVALUE Formula Syntax How do you use the HASONEVALUE function? An equivalent expression for HASONEVAL...

“I truly appreciate your efforts in helping the ones who needed to get more professional help in using Power BI. Your videos are A+ and really helpful+inspiring for me. I wish you the best from Turkey.”

Erol Yücel

“I have taken couple of courses from Sam from Enterprise DNA. I really liked the course. Its well explained, organized and importantly all the datas and formulas & even dashboards are available for everyone.”

Mahesh T, London

“Enterprise DNA has greatly increase my ability to report within our company forever. I went from knowing nothing about Power BI to using it on a daily basis in 30 days simply by watching Sam’s videos & executing his technique.”

Geoff Ellis

“Sam has a very hands-on approach to his training, and is always willing to help! Been apart of several different DAX classes, & Sam’s training is by far the best I have come across.”

Matt Ballinger

“I am really thankful to Sam for helping me through the Power BI. I was a newbie and his hands-on approach and business-oriented approach is all we need. Great work Sam. Keep going!”

Sourabh

“Thanks to Enterprise DNA training! I have improved my Power BI tool skills and have a deeper understanding of data analytics. Sam does an excellent job teaching and problem-solving.”