Average Per day

[qv]

I have done a bit of search in the forum & couldn't find scenario matching with one that I have got, hence this post.

Scenario here is if I am running Daily/Magazine distribution centre and delivering them directly to my subscribers as per the below annexed table.. I would like to ascertain the below :

a) Average minutes taken per day (composite of Dailies, Weeklies & Monthly)

Description	Category	Frequency	Time taken (in Mins)	Days	Total time consumed per day (Time Taken (in Mins) <divided by> Days)
The New York Times	Newspaper	Daily	50	1	50.00
USA today	Newspaper	Daily	30	1	30.00
Chicago Tribune	Newspaper	Daily	20	1	20.00
The Wall Street Journal	Newspaper	Daily	40	1	40.00
The Washington Post	Newspaper	Daily	35	1	35.00
Cosmopolitan	Magazine	Weekly	120	7	17.14
Sports illusrated	Magazine	Weekly	75	7	10.71
People	Magazine	Weekly	60	7	8.57
Los Angeles Times	Magazine	Weekly	110	7	15.71
National Geographic	Books	Monthly	180	30	6.00
Vanity Fair	Books	Monthly	110	30	3.67
Golf Magazine	Books	Monthly	140	30	4.67
					20.12

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but please try something like below.

I tried to create a sample pbix file like the attached file.

expected result measure: = 
AVERAGEX(Data, 
    DIVIDE(Data[Time taken (in Mins)], Data[Days])
    )