Countif in DAX

[Anonymous]

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 numbers which have BAU as 'A'.

BAU is a measure created.

Any help is appreciated!

Thank you!

Megha

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Measure =
  VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU])
RETURN
  COUNTROWS(FILTER(__Table,[__BAU]="A"))

[Anonymous]

Thank you! @Greg_Deckler