Filter and calcuatetable not working.

[mac2]

In power BI creating a column using DAX is working but measures doesn't. I have tried a simple table:

StudentId	Name	Gender	Column
1	Alex	M	1
2	Peter	M	1
3	Jyoti	F	0
4	Rita	F	0

Column = If('Table'[Gender]="M",1,0) This works But the measure:

FilteredStudents = FILTER( Students, Students[Gender] = "F") doesn't work.

FilteredStudents = CALCULATETABLE( Students, Students[Gender] = "F") this doesn't work either.

when i type total_student = calculate(stu it should give me an option to select but it only show details about calculated columns.

 

[mac2]

error: The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.

 

[Chihiro]

How are you using your measure? Context of DAX measure evaluation is critical in order for us to help you.
But why do it in measure? That's column transformation type operation and best done in PQ stage. Not in data model using DAX.

What is your end goal?