Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DISTINCTCOUNTNOBLANK

Hi, I have following data -                 And following measures - CategoryCount = DISTINCTCOUNT(Category_Sales[Category]) CategoryCountNoBlank = DISTINCTCOUNTNOBLANK(Category_...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    Anonymous -

     

    I do not know the reason why however, you could filter out the blanks by:

    Measure = 
CALCULATE(
    DISTINCTCOUNT(Category_Sales[Category]),
    FILTER(
        Category_Sales,
        Category_Sales[Category] <> BLANK()
    )
)

    returns 3.

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
7 years ago

Anonymous -

 

I do not know the reason why however, you could filter out the blanks by:

Measure = 
CALCULATE(
    DISTINCTCOUNT(Category_Sales[Category]),
    FILTER(
        Category_Sales,
        Category_Sales[Category] <> BLANK()
    )
)

returns 3.