Replace value of a existing measure based on other column

[vijaykumarj19]

Attribute	M1	M2	M3	M4	M5	M6
A1	12	2	5	4	43	5
A2	22	3	4	5	44	2
A3	33	5	4	2	5	4
A4	3	6	3	5	2	5

Above is a matrix visual Attribute is row

M1,M2....... are values and they are measures.

M1 = calculate(count(id),filter......)

Required

Attribute	M1	M2	M3	M4	M5	M6
A1	12	2	NA	NA	NA	5
A2	22	3	4	5	44	2
A3	33	5	4	2	5	4
A4	3	6	3	5	2	5

[amitchandak]

@vijaykumarj19 , what is logic.

example

new M3 =If(max(Table[Attribute]) = "A1" ,"NA",[M3] & "" ) // you can return only one type of data type

new M3 =If(max(Table[Attribute]) = "A1" ,blank() ,[M3]) // return blank

[vijaykumarj19]

Then i can cant return two datatypes 

M3 logic = calculate(count(id),filter(tb1,tb1[col] = "xyz"))

[V-lianl-msft]

Hi @vijaykumarj19 ,

What you described doesn't make me understand the problem. Can you share the sample pbix and the results you expect?

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.