Excel Power Pivot Dax Formula
Results 1 to 2 of 2

Thread: Excel Power Pivot Dax Formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,585
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel Power Pivot Dax Formula

    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 by gheyman; Aug 21st, 2019 at 11:09 AM.
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

  2. #2
    Board Regular gheyman's Avatar
    Join Date
    Nov 2005
    Location
    Orlando, FL USA
    Posts
    1,585
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel Power Pivot Dax Formula

    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
    G Heyman
    Northrop Grumman - Laser Systems'
    Apopka, FL

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •