Getting week wise count for all rows excluding the row context

Question

Dear Community,&nbsp;I need to get the count of the error per week in matrix for each row without splitting the count per row wise. Have given the data and the required output. Please help me to solve this issue.&nbsp;Please see the image below&nbsp;have given the column calculation highlighted in yellow for reference. Need the matrix to be the percentage of the week's totalData&nbsp;numberSystemErrorLMDateLMDateKeyWeek3078S5Yes2020-02-032020020363333S5Yes2020-01-292020012952142S9Yes2020-02-062020020664391S6Yes2020-02-0420200204675S3Yes2020-01-29202001295497S3Yes2020-01-292020012954579S5Yes2020-01-29202001295839S7Yes2020-01-312020013152682S7Yes2020-01-312020013154598S7Yes2020-01-272020012751367S1Yes2020-02-072020020761993S1Yes2020-02-072020020762296S7Yes2020-02-072020020763506S7Yes2020-02-072020020763159S7Yes2020-02-072020020764743S4Yes2020-02-062020020662310S8Yes2020-01-292020012953296S7Yes2020-01-29202001295140S7Yes2020-01-30202001305356S7Yes2020-01-292020012953533S6Yes2020-01-28202001285543&nbsp;Yes2020-01-27202001275404S1Yes2020-02-052020020563953S7Yes2020-01-30202001305622S7Yes2020-01-302020013054009S6Yes2020-01-30202001305438S6Yes2020-01-29202001295464S2Yes2020-01-292020012953702S6Yes2020-01-272020012754682S5Yes2020-02-062020020662189S7Yes2020-02-062020020663777S7Yes2020-01-312020013152894S7Yes2020-02-072020020761742S6Yes2020-01-282020012853235S7Yes2020-01-282020012854750S7Yes2020-01-28202001285&nbsp;Thanks in advance.

hotchilli · Answer

Create 3 measures:
Error Count = COUNT(TableDa[Error])

WeekErrors = CALCULATE([Error Count], ALLEXCEPT(TableDa, TableDa[Week]))

ErrorCount% = DIVIDE([Error Count], [WeekErrors])
&nbsp;
In a matrix,
put System in Rows,
Week in Columns,
[Error Count] and [ErrorCount%] in Values

anonymous · Answer

Hi&nbsp;HotChilli&nbsp;,Thanks for your immediate response.&nbsp;I tried the solution you gave and im still getting the total for the week getting split as the system in the rows. Please see the image below.I need the 9 Week Errors as the total of week that is 23 for 5 &amp; 13 for 6 in the column so i could get the respective error %.&nbsp;Please suggest. Thanks in Advance

hotchilli · Answer

Post your pbix and i'll have a look.
This is what I get at my end

anonymous · Answer

Hi&nbsp;HotChilli&nbsp;,&nbsp;I am having the Week from the a date table and joined the same via the Datekey in the source table. does this solution will work only if the week is from the same table?.&nbsp;Please let me know.&nbsp;Thanks.

Forum Discussion

Getting week wise count for all rows excluding the row context

4 Replies

Related content

Measure excluding row context

Context Transition in DAX

Get count in filtered context

Not passing context to Tooltip page

Get period context

number	System	Error	LMDate	LMDateKey	Week
3078	S5	Yes	2020-02-03	20200203	6
3333	S5	Yes	2020-01-29	20200129	5
2142	S9	Yes	2020-02-06	20200206	6
4391	S6	Yes	2020-02-04	20200204	6
75	S3	Yes	2020-01-29	20200129	5
497	S3	Yes	2020-01-29	20200129	5
4579	S5	Yes	2020-01-29	20200129	5
839	S7	Yes	2020-01-31	20200131	5
2682	S7	Yes	2020-01-31	20200131	5
4598	S7	Yes	2020-01-27	20200127	5
1367	S1	Yes	2020-02-07	20200207	6
1993	S1	Yes	2020-02-07	20200207	6
2296	S7	Yes	2020-02-07	20200207	6
3506	S7	Yes	2020-02-07	20200207	6
3159	S7	Yes	2020-02-07	20200207	6
4743	S4	Yes	2020-02-06	20200206	6
2310	S8	Yes	2020-01-29	20200129	5
3296	S7	Yes	2020-01-29	20200129	5
140	S7	Yes	2020-01-30	20200130	5
356	S7	Yes	2020-01-29	20200129	5
3533	S6	Yes	2020-01-28	20200128	5
543		Yes	2020-01-27	20200127	5
404	S1	Yes	2020-02-05	20200205	6
3953	S7	Yes	2020-01-30	20200130	5
622	S7	Yes	2020-01-30	20200130	5
4009	S6	Yes	2020-01-30	20200130	5
438	S6	Yes	2020-01-29	20200129	5
464	S2	Yes	2020-01-29	20200129	5
3702	S6	Yes	2020-01-27	20200127	5
4682	S5	Yes	2020-02-06	20200206	6
2189	S7	Yes	2020-02-06	20200206	6
3777	S7	Yes	2020-01-31	20200131	5
2894	S7	Yes	2020-02-07	20200207	6
1742	S6	Yes	2020-01-28	20200128	5
3235	S7	Yes	2020-01-28	20200128	5
4750	S7	Yes	2020-01-28	20200128	5