Excel Power Pivot Dax Formula

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,730
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.'.
 
Last edited:

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,730
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
 

Watch MrExcel Video

Forum statistics

Threads
1,102,050
Messages
5,484,417
Members
407,438
Latest member
DKrakken

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top