topic Re: Why won't summarize total hours in DAX Commands and Tips

Why won't summarize total hours

Anonymous — Thu, 16 Mar 2023 03:39:17 GMT

Hi Power BI Power Users,

I am trying to sum total hours in Tutor Log_Long. Here is the screenshot of the Tutor Log Long Columns.

Abigail should have three total tutor hours. However, the graph below does not represent what I expect. There is no bar for three. Not sure what I am missing here.

The range of hours should be 0 - 7.5. However, the graph stops at 2.5.

Could someone give me a nudge in the right direction?

Thank you

Re: Why won't summarize total hours

amitchandak — Thu, 16 Mar 2023 04:37:13 GMT

Anonymous , Make sure Axis is categorical

Re: Why won't summarize total hours

Anonymous — Thu, 16 Mar 2023 04:51:40 GMT

Check the formating options, something went wrong there.

Re: Why won't summarize total hours

Anonymous — Thu, 16 Mar 2023 15:24:57 GMT

Hi amitchandak ,

Getting closer.

I made the X-axis categorical.

But I still get this output.

I would like this output. But this output uses wide data. I know there must be a step I am missing to use long data to build a graph just like this one.

My steps to make this unwanted output are as follows.

1. Transform data from wide to long (Tutor Sessions and values)

2. Group tutoring sessions

3. Calculate total hours

Total Hours = 'Tutorial Log_Long'[30-minute Sessions]*0.5

4. Build bar chart X-axis Total Hours, Y-Axis Discount Count of Student ID

The wide data bar chart has X-axis 1st 6 weeks total hours

1st 6 Weeks Total Hours = ('Tutorial Log'[1st 6 Weeks Total Sessions]*.5)

Y-Axis Count of Student IDs

I feel so close.

Any more nudges are greatly appreciated.

Re: Why won't summarize total hours

Anonymous — Sat, 18 Mar 2023 04:00:57 GMT

I figured out the solution.

I needed a measure and a table.

Step 1.

Total Tutoring Hours = SUM('Tutorial Log_Long'[30-minute Sessions])*.5

Step 2.

Tutor Hours by Sessions =

SUMMARIZE(

'Tutorial Log_Long', 'Tutorial Log_Long'[Student ID], 'Tutorial Log_Long'[Sessions Weeks (groups)], "Total Tutor Hours", 'Tutorial Log_Long'[Total Tutoring Hours])

Step 3. Bring in Session Weeks (Group) into the filters

Thank you to everyone. I appreciate the nudges.