Need matrix (& graph) of % by total w/ qualitative data

Question

Hello All,Here are 3 matrices that I am trying to achieve with DAX. I do not want to rely on choosing "show value as percent of column total" on the Visualizations pane, as I need DAX instead:Matrix 1:Matrix 2:&nbsp;Matrix 3: I also would like a 3rd showing gender AND ethnicity but it was getting too complicated to develop an example.Here is a chunk of my data. Please note this is only a small portion of the entire dataset, though the numbers in the example tables above do only reflect this chunk of data. I have many slicers on my dashboard. Thanks in advance!!IDCriteriaRatingGenderEthnicity1Anticipated implications of your research studyWell DevelopedFemaleBlack or African American1Literature review summaryNeeds clarificationFemaleBlack or African American1Organization of your paper and quality of writingNeeds clarificationFemaleBlack or African American1Purpose and focus of your studyWell DevelopedFemaleBlack or African American1Rationale for method/design selectionWell DevelopedFemaleBlack or African American2Anticipated implications of your research studyWell DevelopedMaleWhite2Literature review summaryWell DevelopedMaleWhite2Organization of your paper and quality of writingNeeds clarificationMaleWhite2Purpose and focus of your studyNeeds clarificationMaleWhite2Rationale for method/design selectionWell DevelopedMaleWhite3Anticipated implications of your research studyWell DevelopedFemaleWhite3Literature review summaryNeeds clarificationFemaleWhite3Organization of your paper and quality of writingAcceptableFemaleWhite3Organization of your paper and quality of writingAcceptableFemaleWhite3Rationale for method/design selectionWell DevelopedFemaleWhite4Anticipated implications of your research studyWell DevelopedMaleWhite4Organization of your paper and quality of writingNeeds clarificationMaleWhite4Rationale for method/design selectionWell DevelopedMaleWhite5Anticipated implications of your research studyWell DevelopedFemaleBlack or African American5Literature review summaryNeeds clarificationFemaleBlack or African American5Literature review summaryNeeds clarificationFemaleBlack or African American5Organization of your paper and quality of writingNeeds clarificationFemaleBlack or African American5Purpose and focus of your studyNeeds clarificationFemaleBlack or African American5Rationale for method/design selectionWell DevelopedFemaleBlack or African American6Anticipated implications of your research studyWell DevelopedMaleUnknown6Literature review summaryNeeds clarificationMaleUnknown6Organization of your paper and quality of writingNeeds clarificationMaleUnknown6Purpose and focus of your studyNeeds clarificationMaleUnknown6Purpose and focus of your studyNeeds clarificationMaleUnknown6Rationale for method/design selectionWell DevelopedMaleUnknown7Anticipated implications of your research studyWell DevelopedFemaleWhite7Literature review summaryNeeds clarificationFemaleWhite7Organization of your paper and quality of writingAcceptableFemaleWhite7Organization of your paper and quality of writingAcceptableFemaleWhite7Purpose and focus of your studyNeeds clarificationFemaleWhite7Purpose and focus of your studyNeeds clarificationFemaleWhite7Rationale for method/design selectionWell DevelopedFemaleWhite8Anticipated implications of your research studyWell DevelopedFemaleWhite8Literature review summaryNeeds clarificationFemaleWhite8Literature review summaryNeeds clarificationFemaleWhite8Organization of your paper and quality of writingNeeds clarificationFemaleWhite8Purpose and focus of your studyNeeds clarificationFemaleWhite8Purpose and focus of your studyNeeds clarificationFemaleWhite8Rationale for method/design selectionWell DevelopedFemaleWhite9Anticipated implications of your research studyWell DevelopedFemaleBlack or African American9Literature review summaryNeeds clarificationFemaleBlack or African American9Literature review summaryNeeds clarificationFemaleBlack or African American9Organization of your paper and quality of writingAcceptableFemaleBlack or African American9Organization of your paper and quality of writingAcceptableFemaleBlack or African American9Purpose and focus of your studyNeeds clarificationFemaleBlack or African American9Purpose and focus of your studyNeeds clarificationFemaleBlack or African American9Rationale for method/design selectionWell DevelopedFemaleBlack or African American10Anticipated implications of your research studyWell DevelopedFemaleAsian10Literature review summaryNeeds clarificationFemaleAsian10Organization of your paper and quality of writingAcceptableFemaleAsian10Organization of your paper and quality of writingAcceptableFemaleAsian10Purpose and focus of your studyWell DevelopedFemaleAsian10Rationale for method/design selectionWell DevelopedFemaleAsian11Anticipated implications of your research studyWell DevelopedFemaleWhite11Literature review summaryNeeds clarificationFemaleWhite11Literature review summaryNeeds clarificationFemaleWhite11Organization of your paper and quality of writingAcceptableFemaleWhite11Organization of your paper and quality of writingAcceptableFemaleWhite11Purpose and focus of your studyNeeds clarificationFemaleWhite11Rationale for method/design selectionWell DevelopedFemaleWhite12Anticipated implications of your research studyNeeds clarificationFemaleBlack or African American12Literature review summaryNeeds clarificationFemaleBlack or African American12Organization of your paper and quality of writingNeeds clarificationFemaleBlack or African American12Purpose and focus of your studyNeeds clarificationFemaleBlack or African American12Rationale for method/design selectionWell DevelopedFemaleBlack or African American13Anticipated implications of your research studyWell DevelopedMaleWhite13Literature review summaryNeeds clarificationMaleWhite13Literature review summaryNeeds clarificationMaleWhite13Organization of your paper and quality of writingAcceptableMaleWhite13Organization of your paper and quality of writingAcceptableMaleWhite13Purpose and focus of your studyNeeds clarificationMaleWhite13Rationale for method/design selectionWell DevelopedMaleWhite14Anticipated implications of your research studyWell DevelopedFemaleUnknown14Literature review summaryWell DevelopedFemaleUnknown14Organization of your paper and quality of writingNeeds clarificationFemaleUnknown14Purpose and focus of your studyWell DevelopedFemaleUnknown14Rationale for method/design selectionWell DevelopedFemaleUnknown&nbsp;

johnt75 · Answer

If you have Gender and Ethnicity as separate dimensions you can create a measure like
% = DIVIDE(
&nbsp; &nbsp; [N],
&nbsp; &nbsp; CALCULATE(
&nbsp; &nbsp; &nbsp; &nbsp; [N],
&nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS('Gender'),
&nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS('Ethnicity')
&nbsp; &nbsp; ),
&nbsp; &nbsp; 0
)
See attached PBIX for working example.

samratpbi · Answer

Hi ashleymf1983​&nbsp; based on the sample you have provided, I created a dummy set of data and used visual calculations. Please find the PBI file attached.
Hope this helps to solve your problem. If it does, then please mark it as solution.thanks - Samrat

v-saisrao-msft · Answer

HI ashleymf1983​,
Have you had a chance to review the solution shared by johnt75​ samratpbi​&nbsp;? If the issue persists, feel free to reply so we can help further.
Thank you.

praful_potphode · Answer

Hi ashleymf1983​&nbsp;
try sample pbix.
Please give kudos or mark it as solution once confirmed,
Regards,
Praful

v-saisrao-msft · Answer

HI ashleymf1983​,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.

Forum Discussion

Need matrix (& graph) of % by total w/ qualitative data

5 Replies

Related content

Line Graph With Matrix

Fabric graph

Matrix table

Creating Cumulative Graphs

Graph view

ID	Criteria	Rating	Gender	Ethnicity
1	Anticipated implications of your research study	Well Developed	Female	Black or African American
1	Literature review summary	Needs clarification	Female	Black or African American
1	Organization of your paper and quality of writing	Needs clarification	Female	Black or African American
1	Purpose and focus of your study	Well Developed	Female	Black or African American
1	Rationale for method/design selection	Well Developed	Female	Black or African American
2	Anticipated implications of your research study	Well Developed	Male	White
2	Literature review summary	Well Developed	Male	White
2	Organization of your paper and quality of writing	Needs clarification	Male	White
2	Purpose and focus of your study	Needs clarification	Male	White
2	Rationale for method/design selection	Well Developed	Male	White
3	Anticipated implications of your research study	Well Developed	Female	White
3	Literature review summary	Needs clarification	Female	White
3	Organization of your paper and quality of writing	Acceptable	Female	White
3	Organization of your paper and quality of writing	Acceptable	Female	White
3	Rationale for method/design selection	Well Developed	Female	White
4	Anticipated implications of your research study	Well Developed	Male	White
4	Organization of your paper and quality of writing	Needs clarification	Male	White
4	Rationale for method/design selection	Well Developed	Male	White
5	Anticipated implications of your research study	Well Developed	Female	Black or African American
5	Literature review summary	Needs clarification	Female	Black or African American
5	Literature review summary	Needs clarification	Female	Black or African American
5	Organization of your paper and quality of writing	Needs clarification	Female	Black or African American
5	Purpose and focus of your study	Needs clarification	Female	Black or African American
5	Rationale for method/design selection	Well Developed	Female	Black or African American
6	Anticipated implications of your research study	Well Developed	Male	Unknown
6	Literature review summary	Needs clarification	Male	Unknown
6	Organization of your paper and quality of writing	Needs clarification	Male	Unknown
6	Purpose and focus of your study	Needs clarification	Male	Unknown
6	Purpose and focus of your study	Needs clarification	Male	Unknown
6	Rationale for method/design selection	Well Developed	Male	Unknown
7	Anticipated implications of your research study	Well Developed	Female	White
7	Literature review summary	Needs clarification	Female	White
7	Organization of your paper and quality of writing	Acceptable	Female	White
7	Organization of your paper and quality of writing	Acceptable	Female	White
7	Purpose and focus of your study	Needs clarification	Female	White
7	Purpose and focus of your study	Needs clarification	Female	White
7	Rationale for method/design selection	Well Developed	Female	White
8	Anticipated implications of your research study	Well Developed	Female	White
8	Literature review summary	Needs clarification	Female	White
8	Literature review summary	Needs clarification	Female	White
8	Organization of your paper and quality of writing	Needs clarification	Female	White
8	Purpose and focus of your study	Needs clarification	Female	White
8	Purpose and focus of your study	Needs clarification	Female	White
8	Rationale for method/design selection	Well Developed	Female	White
9	Anticipated implications of your research study	Well Developed	Female	Black or African American
9	Literature review summary	Needs clarification	Female	Black or African American
9	Literature review summary	Needs clarification	Female	Black or African American
9	Organization of your paper and quality of writing	Acceptable	Female	Black or African American
9	Organization of your paper and quality of writing	Acceptable	Female	Black or African American
9	Purpose and focus of your study	Needs clarification	Female	Black or African American
9	Purpose and focus of your study	Needs clarification	Female	Black or African American
9	Rationale for method/design selection	Well Developed	Female	Black or African American
10	Anticipated implications of your research study	Well Developed	Female	Asian
10	Literature review summary	Needs clarification	Female	Asian
10	Organization of your paper and quality of writing	Acceptable	Female	Asian
10	Organization of your paper and quality of writing	Acceptable	Female	Asian
10	Purpose and focus of your study	Well Developed	Female	Asian
10	Rationale for method/design selection	Well Developed	Female	Asian
11	Anticipated implications of your research study	Well Developed	Female	White
11	Literature review summary	Needs clarification	Female	White
11	Literature review summary	Needs clarification	Female	White
11	Organization of your paper and quality of writing	Acceptable	Female	White
11	Organization of your paper and quality of writing	Acceptable	Female	White
11	Purpose and focus of your study	Needs clarification	Female	White
11	Rationale for method/design selection	Well Developed	Female	White
12	Anticipated implications of your research study	Needs clarification	Female	Black or African American
12	Literature review summary	Needs clarification	Female	Black or African American
12	Organization of your paper and quality of writing	Needs clarification	Female	Black or African American
12	Purpose and focus of your study	Needs clarification	Female	Black or African American
12	Rationale for method/design selection	Well Developed	Female	Black or African American
13	Anticipated implications of your research study	Well Developed	Male	White
13	Literature review summary	Needs clarification	Male	White
13	Literature review summary	Needs clarification	Male	White
13	Organization of your paper and quality of writing	Acceptable	Male	White
13	Organization of your paper and quality of writing	Acceptable	Male	White
13	Purpose and focus of your study	Needs clarification	Male	White
13	Rationale for method/design selection	Well Developed	Male	White
14	Anticipated implications of your research study	Well Developed	Female	Unknown
14	Literature review summary	Well Developed	Female	Unknown
14	Organization of your paper and quality of writing	Needs clarification	Female	Unknown
14	Purpose and focus of your study	Well Developed	Female	Unknown
14	Rationale for method/design selection	Well Developed	Female	Unknown