Forum Discussion
Grouping occurances
I have 9 columns that capture ratings relating to Income, Education, Lifestyle, Housing, Health, Employment, Crime from 1 - 10. I have created measures that count the occurance of each rating in each column. I am trying to create a table to compare the occurances for each column type, I have created a table with the ratings 1,2,3,4,5,6,7,8,9,10 and this table form the row headings. When I add the measure the occurance all display the same, I have tried create multiply rating tables and creating individual relationships with each measure and this has no effect.
3 Replies
Hi Norman_LBS
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523Hi Rita,
Thanks for reaching out, I have inserted two tables, the first table is the sample data, and the second table is what I'm try to achieve in a table visual. I'm unable to create a single row header column that simply shows Rank number ( 1, 2, 3...) In which all measure can interact the indepentantly.
IMD Crime Housing Health Education Employment Living Income 2 2 2 7 2 4 2 1 4 5 5 7 6 5 2 1 3 5 4 5 4 2 2 1 6 6 8 9 6 8 2 1 5 5 6 10 6 9 2 2 3 3 4 7 2 3 2 2 5 4 6 7 3 9 2 4
8 8 8 6 6 10 1 10
What I'm trying to achieve, so IMD decile show that 5 areas were ranked 1, 34 ranked 2, 51 ranked 3......
Hope that makes sense
Thanking you in advance
Ranking IMD Decile Income Decile Employment Decile Education and Skills Decile Health and Disability Decile Crime Decile Barriers to Housing and Services Decile Living Environment Decile IDACI Decile IDAOPI Decile 1 5 13 1 0 2 26 34 34 26 86 2 34 45 24 0 14 35 97 59 58 32 3 51 36 39 3 28 31 21 48 33 22 4 28 22 29 9 41 33 10 23 15 19 5 17 20 25 28 29 16 8 12 8 3 6 20 16 21 35 30 20 3 1 13 3 7 8 7 11 31 18 7 2 0 10 6 8 9 4 4 19 7 4 1 0 6 2 9 4 3 7 26 5 5 1 0 6 3 10 1 11 16 26 3 0 0 0 2 1
