Forum Discussion

Bpark1994's avatar
Bpark1994
Icon for Helper I rankHelper I
5 years ago

Need Dax Help Please!

Hi Guys,   I have a table with a task code column and a count column. Im trying to add a calculated column to give me the desired result below. I need tasks 51E and 51F to be added together but the...
DAX
Model
POWER BI Dax rules
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Bpark1994 , Try a new column

if([Task Code] in {"51E","51F"} , sumx(filter(Table,[Task Code] in {"51E","51F"}),[Count]), [Count])