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 numbers which have BAU as 'A'.
BAU is a measure created.
Any help is appreciated!
Thank you!
Megha
Anonymous Try:
Measure = VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU]) RETURN COUNTROWS(FILTER(__Table,[__BAU]="A"))
2 Replies
Anonymous Try:
Measure = VAR __Table = ADDCOLUMNS(DISTINCT('Table'[Part No]),"__BAU",[BAU]) RETURN COUNTROWS(FILTER(__Table,[__BAU]="A"))Thank you! Greg_Deckler