Forum Discussion
Helper ISimple Table and Dax makes nonsense.
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")
Super Userdanielboi , try like
Male HC fix/var:=
CALCULATE(
sum([Value]),
filter(Table1, Table1[Type] IN {"Fix", "Var"},
Table1[Gender]="Male") )
refer if if needed http://dataap.org/blog/2019/04/22/difference-between-calculate-with-and-without-filter-expression/
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
danielboi , sorry one mistake from my side
Male HC fix/var:=
CALCULATE(sum([Value]),
filter(Table1, Table1[Type] IN {"Fix", "Var"} &&
Table1[Gender]="Male") )