I have matrix visualization. I am using dax which provides count of emails but total do not match

Question

Hi There,&nbsp;&nbsp;I have report as below:&nbsp;&nbsp;&nbsp;&nbsp;The DAX used for gettting values is&nbsp;3 Service = SUMX( VALUES(factServices[EmailAddress]), IF([Services 1 plus RT] &gt; 2, 1))&nbsp;&nbsp;This is becuase the same user has availed services twice. I want to get the total as 2 which is coming as 1. What I need to do?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi SanjaydeAsra,
Can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly&nbsp;&nbsp;
In addition, you can also take look a at the following link about measure total level calculation issues:
Measure Totals, The Final Word&nbsp;
Regards,
Xiaoxin Sheng

sanjaydeasra · Answer

HI Xiaoxin,&nbsp;&nbsp;Thank you for your reply.&nbsp;Shared article is superb!&nbsp;&nbsp;My problem details are as below:&nbsp;I have users of my website, there are facilitators who are trying to help users to avail the resources on website.&nbsp;&nbsp;Resources details are as below:&nbsp;User&nbsp; Month&nbsp; &nbsp;Facilitator&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Resource name&nbsp;U1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;R1U2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb&nbsp; &nbsp; &nbsp; F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;R2U2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mar&nbsp; &nbsp; &nbsp;F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;R3U4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Feb&nbsp; &nbsp; &nbsp; F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R2U4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mar&nbsp; &nbsp; &nbsp; F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R6U4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Mar&nbsp; &nbsp; &nbsp; F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R8U5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; &nbsp;F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R1U5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; &nbsp;F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R2U5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Mar&nbsp; &nbsp; F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R4U5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Apr&nbsp; &nbsp; F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; R6&nbsp;I want an output as&nbsp;Facilitator F1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; &nbsp; Mar&nbsp; &nbsp; APR&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Tot&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;First&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Second&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; Three or moreFacilitator F2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Second&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp;&nbsp; Three or more &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1Facilitator F3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; First&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Second&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Three or more&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 2 (Here I am getting 1 )&nbsp;&nbsp;The reason is user is same . If the user ID is different, this issue does not arise.&nbsp;&nbsp;I hope this helps you to analyze and propose a solution.&nbsp;&nbsp;- Sanjay&nbsp;

anonymous · Answer

HI&nbsp;SanjaydeAsra,
I'd like to suggest you add a group index in the query editor, then you can create a calculated column to setting levels based on index values.
Numbering Grouped Data in Power Query • My Online Training Hub
After these steps, you can use Facilitator, and above custom field as row, month as the column, row table value fields as value to achieve your requirement.
Regards,
Xiaoxin Sheng

Forum Discussion

I have matrix visualization. I am using dax which provides count of emails but total do not match

3 Replies

Related content

Matrix Visual Duality

Custom Matrix Visual

Power Matrix visual

Formatting Matrix Visuals

Matrix visual