Just not understanding measures and aggregation

[kosmo]

I need some help. I know what I'm trying to do is probably easy, but man, I'm stuck.

Here's what I have. 

raw_source: a table containing raw source days. selected columns include:

ORDER_PROCEDURE

TRANSCRIBE_DATE

STUDENT

procedure_mapping

ORDER_PROCEDURE

MODALITY

GROUPED_SUBSPECIALTY

RVU

Students

STUDENT_NAME

I have defined a calculated table with rows:

GROUPED_SUBSPECIALTY

TRANSCRIBED_DATE

Transcription-Day

Transcription-Hour

STUDENT_NAME

RVUs

I would like to create a report summaring:

Average RVUs per GROUPED_SUBSPECIALTY by Transcription-Day (M, T, W, T, F, S, S)

Average RVUs per GROUPED_SUBSPECIALTY by Transcription-Hour (M, T, W, T, F, S, S)

Average RVUs per STUDENT_NAME per date, month, year

Average RVUs/hr per GROUPED_SUBSPECIALTY

I know this shows an elementary lack of understanding of measures, and perhaps an inappropriate use of a calculated table. Can someone please help me out and give me some pointers? Need to understand how this works.

[kosmo]

Ok, I've actually created a set of dummy data, scrubbed for privacy.

Here's a link to the files: 

https://www.dropbox.com/sh/9eb6q4pw21khg03/AAD1nx1TfUQMY-Jexo6HqO6-a?dl=0

The problem is on Page 1 Visualization.

I would like the column labeled Average of RVUs to provide the average value of total RVUs performed on particular day, rather than the average RVU of a particular procedure performed on a particular day.  This would be akin to the average total sales in a store on a given day, rather than the average value of a sale on a particular day. 

[v-huizhn-msft]

Hi @kosmo,

As what @mattbrice said, please share sample table. It's really hard to reproduce your scenario based on your description.

Best Regards,
Angelia

[mattbrice]

You’ll need to list how tables are related, and desired output. May be easier to provide a sample file for someone to help.