To count max in row

[harshagraj]

Hi all i need to display as higlighted on the Image. Here the total unique count of Tools are 5. 
Eg Count of T1 will be 2 Because  D & E are at T1 and Count of T4 is 1 because A is at T4. 
Kindly help to achieve this.

[amitchandak]

@harshagraj , These T1, t2 members are column or dimension members.

What is the format of the raw data. please share example

[amitchandak]

@harshagraj , These T1, t2 members are column or dimension members.

What is the format of the raw data. please share example

From now on I can think

if it's measures

_t1 distinctCOUNT(Table[T1])
_t2 distinctCOUNT(Table[T2])
table table _t3 table in the table of different characteristics table([T3])

and more

then treat as
calculatecalculate(countx(values(Table[tool]),_t1),filter(Table, isblank(_t2) && isblank(_t3))

[harshagraj]

hi @amitchandak thanks for the reply. Actually they are all Caluclated Colomns based on DateDiff(Weeks).

[amitchandak]

Then something like this

calculate(countx(values(Table[tool]),_t1),filter(Table, isblank(_t2) && isblank(_t3))

or this should work

countx(filter(summarize(Table,Table[tool], "_t1" , distinctCOUNT(Table[T1]), "_t2" , distinctCOUNT(Table[T2])
, "_t3" , distinctCOUNT(Table[T3]) ,, "_t4" , distinctCOUNT(Table[T4])),
isblank([_t2]) && isblank([_t3]) && isblank([_t4])),[_t1])

[harshagraj]

hi @amitchandak  thank you for the responce. Pleases help me i am totally confused andunable to replicate the formula below. Please tell me if it is a Calculated Measure or Column. Actual Table name is PPR and Column names are Tool Number and Date Diff column names are T0,T1,T2,T3 & T4.

[amitchandak]

@harshagraj , I suggested measures. If this did not work

Can you share sample data and sample output.

[harshagraj]

Hi @amitchandak i tried the other calculation but unfortunately it didnt work. Please find the below sample data.
Eg: Tool Number 9 - A is at T3 so it should not be counted in T0,T1,T2.
      Tool Number 41- A  is at T2 so it should not be counted in T0,T1 & T3
Here the total tool count of tool number is 100. The required output is I need count of T0,T1,T2,T3
(Hint:Count of Tool(100)= Count(T0)+Count(T1)+Count(T2)+Count(T3))

Hi @amitchandak i tried the other calculation but unfortunately it didnt work. Please find the below sample data.
Eg: Tool Number 9 - A is at T3 so it should not be counted in T0,T1,T2.
      Tool Number 41- A  is at T2 so it should not be counted in T0,T1 & T3

1-A				0
2-A				4
3-A				4
4-A				0
5-A				0
6-A				4
7-A				0
8-A				13
9-A	17	18	47	19
10-A	17	15	18	26
11-A	17	15	18	26
12-A	16	21	14	21
13-A	19	75	11	12
14-A	19	24	35	39
15-A	15	15	32	8
16-A	15	15	36	8
17-A	15	15	32	8
18-A	15	15	32	8
19-A	15	15	32	8
20-A	15	15	36	8
21-A	19	26	36	63
22-A	60	14	21	8
23-A	60	14	21	8
24-A	60	14	21	8
25-A	60	14	21	8
26-A	18	22	61	0
27-A	6	6	110	2
28-A	19	23	45
29-A	20	38	4	0
30-A	22	38	4	0
31-A	22	38	4	0
32-A	20	24	19	69
33-A	19	24	66
34-A	22	38	4	0
35-A	22	24	15	72
36-A	57	59	84	25
37-A	3	-6	47	37
38-A	23	22	62	33
39-A	23	23	55
40-A	15	16	100	9
41-A	24	25	58
42-A	24	22	51
43-A	28	34	24
44-A	17	26	14	48
45-A	15	-2	10	11
46-A	15	-2	10	11
47-A	15	-2	10	11
48-A	36	41	56	18
49-A	22	22	-22	0
50-A	36	42	57	24
51-A	23	26	33	0
52-A	4	4
53-A	38	37	3	40
54-A	44	49	4
55-A	31	39	69	8
56-A	43	43	4	68
57-A		16	59
58-A	49	51	10	11
59-A	49	51	10	11
60-A	49	51	10	11
61-A	27	29	0	0
62-A	30	-58	63	0
63-A	25	-49	0	0
64-A		-53	0	0
65-A	25	-49	0	0
66-A		-54	0	0
67-A	25	-49	0	-4
68-A	20	25	32	5
69-A	13	-49	83	0
70-A	13	-49	83	-19
71-A	26	31	14	0
72-A	26	31	14	5
73-A	26	31	46	5
74-A	56	63	34	23
75-A	40	-46
76-A	67	67	10	5
77-A	67	67	10	5
78-A	67	67	10	5
79-A	148	21	14	12
80-A	148	21	14	12
81-A	148	21	14	12
82-A		-44	0	0
83-A	30	35	17	0
84-A	30	35	17	0
85-A	29	29
86-A	5	-43	45	18
87-A	59	69	28
88-A		40
89-A		40
90-A		40
91-A	15	18	2
92-A	15	18	1
93-A	15	18	1
94-A	15	18	1
95-A	15	18	5
96-A	15	18	1
97-A	15	18	1
98-A	22	-40	75	-19
99-A	22	-40	75	0
100-A	23	-39	74	46

Hi @amitchandak i tried the other calculation but unfortunately it didnt work. Please find the below sample data.
Eg: Tool Number 9 - A is at T3 so it should not be counted in T0,T1,T2.
      Tool Number 41- A  is at T2 so it should not be counted in T0,T1 & T3

[harshagraj]

hi @amitchandak @parry2k  could you please help me?