How to write a Dax query with creating a new measure

[HugoTran]

Hi All - Need help in writing a dax query with creating a new measure where Status = Future Production Change and SME group, Target Release Date, Disposition Reference are populated and Resolution date are not populate (blank). Thanks.

[gadielsolis · Accepted solution]

Hello.

Not sure if I understand correctly but lets assume you want to sum the values in the "Table[a]", if that's the case you can try the following DAX:

Sum_of_a= Calculate(Sum(Table[a]),Table[Status]="Future Production Change"&&ISBLANK(TargetReleaseDate))&&
ISBLANK(DispositionReference)&&NOT(ISBLANK(ResolutionDate)))

[HugoTran]

that work! thanks a bunch.