Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculated Measures vs Calculated Columns

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.

 

 

 

 

 

 

Help

2 Replies

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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