Filer and Calculate in Same Col with Date, to create another Col ou Row

[susigan]

Hi Everyone.

Before This i have a Table like this one

Activity Date RPE Time X Y Z
Bike 20/12 5 00:50 0 1 2
Row 20/10 3 00:32 0 1 2
Run 22 /12 00:47 0 1 2

Then i realize i will need transpose evey Activity seprate and Duplicate tables, will be a pain in the ***.
And changed this on Excel to

Activity Date Metric Value
Bike 20/12 RPE 5
Row 20/10 Time 00:32
Run 22 /12 X 2

But turn out in another problem, because Time and Decimal Number , Same format give me alot of errors, I solve that manually in excel

I tried create calculate Time and RPE and multiply both to create another Column or Add another row Metric/Value/Date in already exists columns - OR just a Measure?

Maybe something like this? - But i need to find right DAte with both values - This could be just a Measure


[Sales Red or Contoso - ALL columns filter] :=
CALCULATE (

,
FILTER (
ALL ( 'Table'[Metric], 'Product'[Value] ),
'Product'[Metricr] = "RPE" * 'Product'Value]
)
)

OR sonmething like this

Result =

VAR Value1 = SUMX(FILTER(ALL('Table'), 'Table'[Date].[Value] = Value1), 'Table'[Value])
VAR Metric1 = SUMX(FILTER(ALL('Table'), 'Table'[Date].[Metric] = Value1), 'Table'[Metric])

(((Metric1) * (Value1)