Forum Discussion
Countif in DAX
Hi all, I have a matrix visual created. some of the columns is as below: Part No BAU 111 A 222 A 333 A 444 B I would like to get a count of the number of part n...
Anonymous Try:
Measure = VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU]) RETURN COUNTROWS(FILTER(__Table,[__BAU]="A"))
Greg_Deckler
Community Champion
Community ChampionAnonymous Try:
Measure =
VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU])
RETURN
COUNTROWS(FILTER(__Table,[__BAU]="A"))Thank you! Greg_Deckler