Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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% |
1677 | 61% | |
Radio | 839 | 30% |
TV | 1123 | 41% |
Thanks
Solved! Go to 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
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |