Forum Discussion
Measure based on Field value
I have two measure Total-1 and Total-2. I have a field called Stores which have texts like: "Red","Blue","Pink"...... I want to create a Measure in such a way that Total = Total-1 when [Stores]...
Anonymous add new measure like this and now put stores and new total measure in a table visual and you will get the expected result.
Total = IF( MAX(Table[Stores])="Red", [Total-1], [Total-2])
I have a similar issue but not getting passed the syntax
I have imported 2 Excel Tables in to my Power BI report
I want to create a measure based on a the field value in my row . To keep it simple to start with
msr.MyAccPrefix = LEFT(Table1[FK_AccountCode],3) Well this just gives me a nice red syntax error under my field .. The field does exist so this maybe not understanding the syntax
Looks like my bad: as you can't reference a lone field in a measure as Power BI doesn't know the context , you can only SUM,Average etc muliple field values .