Survey data percentage dax measure

[darko861]

Hi all,

I have the following data displayed in a table visual.

Question_Text	# of Entries	Sentiment	Percent
Are you overall satisfied with the support you received for this case?	4	Excellent	80%
Are you overall satisfied with the support you received for this case?	1	Poor	20%
Are you satisfied with the resolution provided?	4	Excellent	80%
Are you satisfied with the resolution provided?	1	OK	20%
Do you think the time to resolve the case was reasonable?	4	Excellent	80%
Do you think the time to resolve the case was reasonable?	1	Poor	20%
Was the support consultant courteous & professional?	5	Excellent	100%
Was the support technician knowledgeable?	4	Excellent	80%
Was the support technician knowledgeable?	1	OK	20%
Were you kept informed during the progress of the case?	4	Excellent	80%
Were you kept informed during the progress of the case?	1	OK	20%

I want to add a DAX measure called Percent as displayed above to give me the percentage distribution per question.

E.g. Question: Are you overall satisfied with the support you received for this case? 

 4 respondents answered Excellent which is 80 % and 1 respondent answered Poor which is 20 %.

How can I write this Dax Measure?

here is a sample file:

https://www.dropbox.com/s/abuu4wjzb9o5i41/Test1.pbix?dl=0

Thanks for your help 🙂

[Rudy_D]

Hi,

This should work :).

% = 
VAR total = CALCULATE(SUM(Feuil1[# of Entries]), ALLEXCEPT(Feuil1, Feuil1[Question_Text]))
RETURN
DIVIDE(SELECTEDVALUE(Feuil1[# of Entries]), total, 0)

[darko861]

still doesn't work, but I have a sample file please see my original post

[PabloDeheza]

Hi @darko861 !
Try the following measure!

Percent = 
VAR _CurrentEntries =
    SUM( 'Table'[# of Entries] )
VAR _AllEntries =
    CALCULATE(
        SUM( 'Table'[# of Entries] ),
        ALLSELECTED( 'Table'[Sentiment] )
    )
VAR _Result =
    DIVIDE(
        _CurrentEntries,
        _AllEntries
    )
RETURN
    _Result

Let me know if that helps!

[darko861]

Doesn't work, I have a sample file please see the original post

[PabloDeheza · Accepted solution]

Base on the file it should be like this

Percent = 
VAR _CurrentEntries =
    [# of Entries]
VAR _AllEntries =
    CALCULATE(
        [# of Entries],
        ALLSELECTED( Satisfaction[Sentiment] )
    )
VAR _Result =
    DIVIDE(
        _CurrentEntries,
        _AllEntries
    )
RETURN
    _Result

[darko861]

Thanks 🙂