Forum Discussion
danielboi
Helper I
Helper ISimple Table and Dax makes nonsense.
Hello community, I have a simple table where HC information is listed: Cost Center Month Gender Type Value 1 1 Male Fix 2 1 2 Male Fix 3 1 1 Male Var 2 1 2 Mal...
amitchandak Almost!
Need to close the filter argument right after the IN operator.
This way it works. Thanks for showing me the way though!
Male HC fix/var:=
CALCULATE(sum([Value]),
filter(Table1, Table1[Type] IN {"Fix", "Var"}),
Table1[Gender]="Male")
danielboiHelper I
Helper Iamitchandak Almost!
Need to close the filter argument right after the IN operator.
This way it works. Thanks for showing me the way though!
Male HC fix/var:=
CALCULATE(
sum([Value]),
filter(Table1, Table1[Type] IN {"Fix", "Var"}),
Table1[Gender]="Male")
amitchandak
Super User
Super Userdanielboi , sorry one mistake from my side
Male HC fix/var:=
CALCULATE(
sum([Value]),
filter(Table1, Table1[Type] IN {"Fix", "Var"} &&
Table1[Gender]="Male") )