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] = "Red"
Else Total = Total-2
How can I achevie this in DAX ?
Thanks!
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])
3 Replies
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 .
