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
Sean's avatar
Sean
Community Champion
10 years ago

Anonymous :smileylol: :smileylol: :smileylol:

 

 

 

Sean's avatar
Sean
Community Champion
10 years ago

Anonymous With a slight adjustment my formula works on both numbers and text columns - and so does NOT (ISBLANK ...

 

Projects TEXT & NUMBERS = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Project] ),
    FILTER ( 'Table', 'Table'[Project] <> BLANK() )
)

Projects ALT TEXT & NUMBERs  = 
CALCULATE (
    DISTINCTCOUNT ( 'Table'[Project] ),
    NOT ( ISBLANK('Table'[Project]) )
)