Calculated Measures vs Calculated Columns

[Anonymous]

Hello Dazzling DAX users,

I have a conundrum. I can't make the following visuals using calculated measures. - Line Chart, Bar Chart, etc. I am limited to a table.

Here are my calculated measures.

Total Tutoring Hours = SUM(Separate[Tutoring Time (30 Minutes each session)])

Tutoring in HH:MM =

VAR _Min = [Total Tutoring Hours]*30

VAR HourNo = INT(_Min/60)

VAR minuteNo = MOD(_Min, 60)

Return FORMAT(HourNo, "#00") & ":" & FORMAT(minuteNo, "#00")

Work like a charm.

But I can't make the aforementioned visuals with a calculated measure. 

Can only place Tutoring in HH:MM into Tooltips. 

 

Should I use a calculated columns for Total Tutoring Hours and Tutoring in HH:MM?

My goal is to build visual that demonstrate total tutoring hours:minutes by student by day.

Any nudge is greatly appreciated.

[Anonymous]

Hi @FreemanZ - thank you for the nudge.

I thought that by pulling in Total Tutoring Hours that i summed.

But i have to sum in hour in the calculated measure of Tutoring Hours in HH:MM.

Am i understanding you correctly?

Total Tutoring Hours = SUM(Separate[Tutoring Time (30 Minutes each session)])

Tutoring in HH:MM =

VAR _Min = [Total Tutoring Hours]*30

VAR HourNo = INT(_Min/60)

VAR minuteNo = MOD(_Min, 60)

Return FORMAT(HourNo, "#00") & ":" & FORMAT(minuteNo, "#00")

[FreemanZ]

hi @Anonymous 

FORMAT returns text, instead of numeric values, so totaling text doesnt work. 

Try to sum in hour or minute and in the last step format to HHMMSS if needed for each measure.