I am not sure what I am doing wrong. I have several data tables that were brought in using an odata feed.
When I am writing my dax formulas I do not get the drop down when entering the table name. E.g when typing L I should get a list of tables that beginning with L. When I type out the table name and define the column I am getting an error message. It seems my table is not recognised.
I have attached a screenshot of the error message.
I get similar errors when writing any dax formula. Not sure what I am doing wrong.
You’re trying to create a measure, but measures operate at an aggregation level meaning they don’t inherently understand row-level calculations unless you specify the context. As such, intellisense won’t find LedgerEntries[Amount].
This syntax will work if you try creating a calculated column, but to work in a measure you have to properly define the context in which LedgerEntries[Amount] should be accessed and inverted. You can do that with an iterator:
Total Inverted Amount = SUMX(LedgerEntries, LedgerEntries[Amount] * -1)
says…iterate through each row of LedgerEntries, multiply Amount by -1, then sum up all these inverted amounts.
