Forum Discussion

litifeta's avatar
litifeta
Advocate II
10 years ago

Help with a count function in DAX

Having trouble with something that is so simple in Excel   I have a column of project names and blanks. I want a measure to calculate the unique text values so I can determine how many projects are...
Need Help
Baskar's avatar
Baskar
Resident Rockstar
10 years ago

Its cool in Power BI too.

 

1. Look the visual levell filter, from there u can choose advance filter, and pick "Is not Blank"

 

2. Change our measure to "Distinct Count"

 

let me know if i wont work.

litifeta's avatar
litifeta
Advocate II
10 years ago

Still do not know what you mean Baskar. do you mean = DISTINCTCOUNT(<DATA>)

  • Sean's avatar
    Sean
    Community Champion
    10 years ago

    litifeta try this measure

     

    Number of Projects =
CALCULATE (
    DISTINCTCOUNT ( TableName[ProjectsColumn] ),
    FILTER ( TableName, TableName[ProjectsColumn] <> "" )
)
    • litifeta's avatar
      litifeta
      Advocate II
      10 years ago

      sorry. no that did not work. 

      • Baskar's avatar
        Baskar
        Resident Rockstar
        10 years ago

        Can u please the screen shot which u have

  • Baskar's avatar
    Baskar
    Resident Rockstar
    10 years ago

    I will give u 2 suggestion

     

    create measure with filter

     

    1.  Measure = CALCULATE(DistinctCount(Project),FILTER('Table Name',"Project"<>BLANK())

     

    it will filter your Blank()

     

    2. Its based on Visual level filter in development canvas

     

    Drag ur measure on filed and pick Distinct count 

    Next move to Visual level filter, choose advanced filter, there u have to choose "Is not Blank()"

     

    Then apply , i hope it will solve your prob