yes no percentage dax

[Anonymous]

help  please i want to make a clusterd colum visual with % of yes and no answers my data is like this

Name          answer

andrew         yes

peter            no

withney        no

i want to know how many people answert with yes and how many people answert no and i want to show it in a clusterd colum diagram.

hope someone can help me :):)

[PbiwithPrasad]

Take the answer column in x axis and the name column count in y axis you will get the answer.

If you need the % get total name count with out filters and decide by the name count, and drop it in y axis.

[Anonymous]

This doesnt work for me if i place the measure in in the Y axis it gives me 100% by both answers i need a measuere like this:

count answer

count answer divide by yes and now 

[FreemanZ · Accepted solution]

hi @Anonymous 

are you expecting like:

measure = 
VAR _count = DISTINCTCOUNT(TableName[Name])
VAR _countall =
CALCULATE(
    DISTINCTCOUNT(TableName[Name]),
    ALL(TableName[answer])
)
RETURN
DIVIDE(_count, _countall)