Matrix visual help

[GPetroff]

Hi,

I am building the matrix visual

input

Group	Status
1	B
2	A
3	C

matrix that i got to is (each 1 is a count)

Group	A	B	C
1		1
2	1
3			1

i need to multiply each count by 80

Group	A	B	C
1		1*80
2	1*80
3			1*80

since each column is a transposed row, i dont know how to refer to it. maybe there is an easy way. i.e. calculated A

thank you

[GPetroff]

thank you . works great.

one more question if you dont mind.

step 2 that i need to do is to find the difference between  columns B and C (result of transposing). 

[GPetroff]

to provide more context i will provide a better example

Group	A	B	C	still in progress
1	3	3	1	=3-1
2	1
3	3	3	1
Group	A	B	C	Still in progress
1	240	240	80	=240-80
2	80	0	0
3	240	240	80

[GPetroff]

found a solution 

https://community.powerbi.com/t5/Desktop/Difference-between-two-columns-in-matrix-visualisation/td-p...

[JorgePinho · Accepted solution]

Without context I would say that you just need to create a measure like Measure = COUNTROWS(Status)*80 and put in the "Values" of the Matrix.