Measure for "AND" Condition

[joeheng123]

  Hi anybody able to assist i want to change my filter from "OR" to "AND" condition i have tested the Measure command many times but it does not seem to work. The table image show the blank spaces which i do not want to see .

[Greg_Deckler]

@joeheng123 - Did one of these answer your question. If so, please accept as an answer, otherwise @ me. Thanks.

[amitchandak]

@joeheng123 , Try grade measure like

measure =
var _cnt = calculate(distinctcount(Table[subject]),allselected(Table))
return
maxx(filter(summarize(Table,Table[Name], Table[Subject], Table[Grade] ,"_1", calculate(distinctcount(Table[subject]),allexcept(Table,Table[Name]))),[_1]=_cnt),[Grade])

[Greg_Deckler]

@joeheng123 - I created an AND slicer once, https://community.powerbi.com/t5/Quick-Measures-Gallery/Patient-Cohort-AND-Slicer/m-p/391883#M130