How to countif per columns to 1 unique Data

You can just do a reference to the table and create a copy in power query. Then you can do all kinds of pivots without ruining your original table. 

The other solution i had in mind is creating a small table:

Then create a relationship between this column and each of your week columns. The relationships should not be active. 

Finally create measures, along this lines of this:

Week1 = Calculate(countrows([Week1]) ; USERELATIONSHIP( [NewColumn] ; Week1))

Week2 = Calculate(countrows([Week2]) ; USERELATIONSHIP( [NewColumn] ; Week2))

etc...

Finally use the A/B/C column in the new table as a legend or row dimension with the new measures and you should be all set. 

I'm going on lunch but let me know if you need any help!

/ J

Alright, never mind my previous message. Heres the columns:

week1 times = 
VAR cat = Table2[Result]
VAR UT = Table2[Unit Time]
return
CALCULATE(COUNTROWS(Table1) * UT;Table1[Week1] = cat )

week2 times = 
VAR cat = Table2[Result]
VAR UT = Table2[Unit Time]
return
CALCULATE(COUNTROWS(Table1) * UT;Table1[Week2] = cat )

week3 times = 
VAR cat = Table2[Result]
VAR UT = Table2[Unit Time]
return
CALCULATE(COUNTROWS(Table1) * UT;Table1[Week3] = cat )

/ J