microsoft / microsoft/Analysis-Services
Using LINESTX within a measure creates warnings
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 732
- Forks
- 433
- PR merge metrics
- No merged PRs in 30d
Description
I've created a measure that uses the LINESTX function and the DAX definition must reference the columns that are part of the returned table of the function, such as Slope1 and Intercept, see docs: https://learn.microsoft.com/en-us/dax/linestx-function-dax
These create warnings in the validation since they look like measures that are supposed to be defined already in the model.
It could be confusing for others who aren't familiar with the details of the DAX but are making edits and then might be trying to resolve this warning.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the warning with a measure that references LINESTX result columns such as Slope1 and Intercept, using the linked LINESTX documentation for the DAX context. Trace which validation rule treats those names as missing model measures; done means valid references no longer produce misleading warnings.
Written by the indexing model from the issue text.
Assessment
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100