creating a measure that does simple division but also takes filter into account

[Keith011]

Hi there,

this table is my raw data

respondentID	Attribute	Value
1	what is your favourite color	red
2	what is your favourite color	red
3	what is your favourite color	red
4	what is your favourite color	blue
5	what is your favourite color	green
6	what is your favourite color	black
7	what is your favourite color	blue
8	what is your favourite color	blue
9	what is your favourite color	yellow
10	who is your favourite superhero	spiderman
11	who is your favourite superhero	spiderman
12	who is your favourite superhero	superman
13	who is your favourite superhero	batman
14	who is your favourite superhero	batman
15	who is your favourite superhero	batman
16	who is your favourite superhero	batman

I would like to create a measure that does a simple COUNT of Value divided by DistinctCount of respondent ID.

For example,

red would be 3 / 16

blue would be 3 / 16

yellow, black, green would be 1 / 16

spiderman would be 2 / 16

superman would be 1 / 16

batman would be 4 / 16

[Keith011]

why wouldn't this work?

[Mahesh0016]

simple COUNT of value divided by DistinctCount =

VAR countValue = CALCULATE(COUNTROWS(TableName),ALL(TableName))

VAR discount = CALCULATE(COUNT(TableName[Value]),ALLEXCEPT(TableName[Value]))

RETURN

DIVIDE(discount,countValue,0)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos !! 

[Keith011]

Is this done in measure? if Yes, the formula is working but the outcome im getting are 0. It's not doing the right calculations @Mahesh0016