Excel Power Pivot Dax Formula

[gheyman]

I have a table (PivotTable1) where I want to add a measure.

I want to count the number of times a part number appears in one of my Fields (COMP_PART_ID). When I search the internet all I am seeing is PowerBI Dax examples (and not for a Count or CountIf type of formula.

Any help would be appreciated.


I tried
=CALCULATE(COUNT(BOM[COMP_PART_ID]), ALL( BOM[EndItem]))

I Got this when I checked the Formula:
This formula is invalid or incomplete: 'Calculation error in measure 'BOM'[f9ae642d-4ed3-4f0d-95a6-ac06588a12d0]: The function COUNT takes an argument that evaluates to numbers or dates and cannot work with values of type String.'.

 

[gheyman]

Just to add, if this was a regular Excel my formula would be countif([COMP_PART_ID],G7) if I was putting the formula in cell G7