How to calculate time spent on type1 and type 2? Should I use DAX or directly I can drag and drop

[AtchayaP]

Type 1	Type 2
0.05	0.25
3.06	5.26
0.45	0.45
0.55	0.55
0.20	1.20

How to calculate time spent on type1 and type 2?

Should I use DAX  or directly I can drag and drop in card visual type 1 and type 2.

[Anonymous · Accepted solution]

Hi @AtchayaP ,

You could directly put them into visuals and select Sum under Field pane.

Best Regards,

Jay

[amitchandak]

@AtchayaP , You can use two measure

M Type1 = Sum(Table[Type1])

M Type2 = Sum(Table[Type2])

and use in visual

or you can unpivot this table and get type in rows

https://radacad.com/pivot-and-unpivot-with-power-bi