% based on count ignoring blank()

[Dom87326]

Hello, 

I'm trying to build a dax formula that counts % of non discinct RespondentId by total RespondentId (ignoring blanks).

The desired outcome should be like in column % of GT of RespondentId <> Blanks.

Question	RespondentId	Answer	% of GT of RespondentId <> Blanks
What's your favorite city	39	Lora del Río	11%
What's your favorite city	69	Marchena	11%
What's your favorite city	71	Moron de la Frontera	11%
What's your favorite city	31	Barcelona	11%
What's your favorite city	57	Madrid	11%
What's your favorite city	38
What's your favorite city	68
What's your favorite city	81	Huesca	44%
What's your favorite city	53	Huesca	44%
What's your favorite city	16	Huesca	44%
What's your favorite city	64	Huesca	44%

Thanks!

[AilleryO · Accepted solution]

Hi,

Not 100% sure, but I will try to help :

Count Non Blank Answers = 
VAR CountNonBlankAnswers=CALCULATE( COUNT( TabAnswers[RespondentId] ) , NOT ISBLANK( TabAnswers[Answer] ) )
RETURN
CountNonBlankAnswers

Will give you the count of answers not blank. Then if you want to count each type of answer, this would do the job :

Count Non Blank Answers / Answer = 
VAR CurrentAnswer= SELECTEDVALUE( TabAnswers[Answer] )
VAR CountNonBlankAnswers=CALCULATE( COUNT( TabAnswers[RespondentId] ) , NOT ISBLANK( TabAnswers[Answer] ) , TabAnswers[Answer] = CurrentAnswer )
RETURN
CountNonBlankAnswers

Then if those are the count you need, you'll just have to divide :

% of answers = DIVIDE ( Count Non Blank Answers , Count Non Blank Answers / Answer , 0 )

and get that :

Hope it helps