Measure based on Field value

[Anonymous]

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!

[westerdaled]

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

[westerdaled]

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 .

[parry2k · Accepted solution]

@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])