Issue with achieving percentage of multi select variable post un-pivot.

[shekharlko23]

Hi, I have data for N= 2757 respondents and have multi response answer. After unpivot of data I'm able to achieve below counts but not able to achieve below mentioned target percentages. as percentages coming up in chart is summing upto 100% . 

Each percentage is calculated by each Count/2757. Please suggest how to achieve below %'s

 Category Count  Percentage

Mobile	2180	79%
Online	2643	96%
Outdoor	1275	46%
Print	1677	61%
Radio	839	30%
TV	1123	41%

Thanks

[TomMartens · Accepted solution]

Hey @shekharlko23 ,

i created this measure:

Measure = 
IF(
    HASONEVALUE('Table'[Category])
    , DIVIDE(SUM('Table'[Count]) , 2757)
    , BLANK()
)

This allows to create this table visual ...

... but I have  to admit that I do not have an idea what you are looking for.

If you are looking for a certain visual, please attach an image, just make a sketch that allows to understand what you want.

Regards,

Tom

[shekharlko23]

Hi @TomMartens , Thanks for your help.

I was able to achieve these % within clustered column chart, is this correct chart to represent multi select %'s?

Also how can I add % sign to these numbers in measure?

Thanks!