Creating a new Table based on data from another table using DAX

[Anonymous]

Hello Community,

I have loaded in a table-1 Containg the following 

I need to have the data formated as below in another table..

	Average Time Spent
Time Spent in Room A	xxx
Time Spent in Room B	xxx
Time Spent in Room C	xxx
Time Spent in Room D	xxx
Time Spent in Room E	xxx
Time Spent in Event	xxx

But when I calculate the Average .. I want to eliminate all "0" and the calculate Average..

is there a possible solution for this?

Thanks

[Anonymous · Accepted solution]

Used Unpivot columns option.. Thanks