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.
Hello, community members.
I have been studying DAX function. ( URL : https://msdn.microsoft.com/query-bi/dax/calculate-function-dax)
There was something over an hour I couldn't understand.
There's nothing wrong right now, but I'm really curious about what that means.
-----------------------------------------------------------------------------------------------------------------------------------------
The following restrictions apply to Boolean expressions that are used as arguments:
The expression cannot reference a measure.
The expression cannot use a nested CALCULATE function.
The expression cannot use any function that scans a table or returns a table, including aggregation functions.
-------------------------------------------------------------------------------------------------------------------------------------------
Could anyone please give me examples or explanations?
Solved! Go to Solution.
this reference is much more extensive
https://www.sqlbi.com/articles/context-transition-and-filters-in-calculate/
regarding the boolean expression specifically (this is where the limitations are valid) e.g. check if color is red
CORRECT CALCULATE(SUM(Table[Value]),Table[Color] = "Red") CALCULATE(SUM(Table[Value]),LOWER(Table[Color]) = "red") NOT CORRECT Flag1 = IF(Table[Color] = "Red", TRUE,FALSE) CALCULATE(SUM(Table[Value]),[Flag])
nested CALCUALTE is quite self explanatory, function that scans a table - my guess would be e.g. SUMX, FILTER (though I'm not sure about them)
please remember that instead of a boolean expression you can also pass a list of values - e.g. result of FILTER, DATESYTD, etc.
this reference is much more extensive
https://www.sqlbi.com/articles/context-transition-and-filters-in-calculate/
regarding the boolean expression specifically (this is where the limitations are valid) e.g. check if color is red
CORRECT CALCULATE(SUM(Table[Value]),Table[Color] = "Red") CALCULATE(SUM(Table[Value]),LOWER(Table[Color]) = "red") NOT CORRECT Flag1 = IF(Table[Color] = "Red", TRUE,FALSE) CALCULATE(SUM(Table[Value]),[Flag])
nested CALCUALTE is quite self explanatory, function that scans a table - my guess would be e.g. SUMX, FILTER (though I'm not sure about them)
please remember that instead of a boolean expression you can also pass a list of values - e.g. result of FILTER, DATESYTD, etc.
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |