Forum Discussion

qv's avatar
qv
New Member
2 years ago
Solved

Average Per day

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)

 

DescriptionCategoryFrequencyTime taken (in Mins)DaysTotal time consumed per day
(Time Taken (in Mins) <divided by> Days)
The New York TimesNewspaperDaily50150.00
USA todayNewspaperDaily30130.00
Chicago TribuneNewspaperDaily20120.00
The Wall Street JournalNewspaperDaily40140.00
The Washington PostNewspaperDaily35135.00
CosmopolitanMagazineWeekly120717.14
Sports illusratedMagazineWeekly75710.71
PeopleMagazineWeekly6078.57
Los Angeles TimesMagazineWeekly110715.71
National GeographicBooksMonthly180306.00
Vanity FairBooksMonthly110303.67
Golf MagazineBooksMonthly140304.67
     20.12
DAX AVERAGE
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    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])
    )

1 Reply

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    2 years ago

    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])
    )