Evaluation context and its transition is one of the hardest concepts in DAX and I would find it extremely helpful, if syntax highlighting would assist us here: Let the colour of the table name show whether the expression will be evaluated: in a row context (so the table name represents the record/current row and a scalar value will be returned, Color: purple). In a filter context (so the table name represents the (eventually filtered) table and a list of its column values is returned instead, Color: gold. Ideally, it would also indicate if a filter is active or not (or can become active once the measure is used in a pivot table). So with an empty filter, there would be no syntax highlighting. I've described this idea in my blogpost here: http://wp.me/p6lgsG-KI
3 Comments
- renaudmassonNew MemberI agree, remembering what each DAX function does, even after 1.5 year using power BI, is just not possible. Excel offers in-line help when typing a function, power BI should be able to do the same
- carlos_kynaslahNew MemberThis is one of the most frustrating parts of using Power BI, the lack of a proper editor & syntax highlighting. Nesting functions gets very ugly very fast without this feature.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Fix links generated in multi tenant setups
When I log into Fabric, and I have access to multiple tenants, the links generated for things like monitoring URLs in pipeline runs do not include "ctid=<tenantguid>" query string value, which appear...jwisemanfs31 minutes agoNew MemberNew2Views0likes0CommentsDedicated Fabric Message Center to communicate planned Fabric Changes
Summary Microsoft recently rolled out a change that automatically enabled the Item Recovery tenant setting in Microsoft Fabric for tenants where the setting had not been explicitly configured. Accor...Edgar_9 hours agoNew MemberNew33Views5likes0CommentsWorkspace-Level Control of Storage Modes (Import vs DirectQuery vs Direct Lake)
Organizations operating under strict governance and data residency requirements need the ability to control which storage modes are permitted within a workspace. Currently, report authors can choose...masoodaftab10 hours agoNew MemberNew6Views0likes0CommentsGranular Workspace Permissions Beyond Workspace Roles
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } The current workspace access model is limited to the predefined workspac...masooddevcorp10 hours agoNew MemberNew19Views1like0Comments