Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count by Blank Text

I am trying to count the number of hotels in "Hotel Names" that have blank "Descriptions" in the table below. My current measures keep on counting repeated names as additional hotels. Please help.

Need Help
  • dax's avatar
    dax
    6 years ago

    Hi acohen-ih-corp,

    Did you want to get below result?

    You could try below measures

    Measure =
CALCULATE (
    COUNT ( 'count'[hotel] ),
    FILTER ( ALLEXCEPT ( 'count', 'count'[hotel] ), 'count'[description] = BLANK() )
) + 0
Measure 2 =
CALCULATE (
    DISTINCTCOUNT ( 'count'[hotel] ),
    FILTER (  'count',  'count'[description] = BLANK() )
)

    If this not waht you want, please correct me and inform me your expected output.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • dax's avatar
    dax
    Community Support
    6 years ago

    Hi acohen-ih-corp,

    Did you want to get below result?

    You could try below measures

    Measure =
CALCULATE (
    COUNT ( 'count'[hotel] ),
    FILTER ( ALLEXCEPT ( 'count', 'count'[hotel] ), 'count'[description] = BLANK() )
) + 0
Measure 2 =
CALCULATE (
    DISTINCTCOUNT ( 'count'[hotel] ),
    FILTER (  'count',  'count'[description] = BLANK() )
)

    If this not waht you want, please correct me and inform me your expected output.

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.