Forum Discussion

lewisbaybutt5DT's avatar
lewisbaybutt5DT
Regular Visitor
4 years ago
Solved

Related calculated column

I have three tables in dataverse. A case table, session bookings table and a session types table. My session bookings table has lookups to both the 'case' and 'session type'. My session types table h...
General Comment
  • AllisonKennedy's avatar
    AllisonKennedy
    4 years ago

    lewisbaybutt5DT  Create new measures and put them in a visual with CaseTable[CaseType]: 

     

    Total Cost = SUMX(SessionBookings, RELATED( SessionTypes[SessionLength] ) * RELATED( SessionTypes[SessionLength] ) )

     

    Total Duration = SUMX(SessionBookings, RELATED( SessionTypes[SessionLength] ) )

AllisonKennedy's avatar
AllisonKennedy
Community Champion
4 years ago

lewisbaybutt5DT  Create new measures and put them in a visual with CaseTable[CaseType]: 

 

Total Cost = SUMX(SessionBookings, RELATED( SessionTypes[SessionLength] ) * RELATED( SessionTypes[SessionLength] ) )

 

Total Duration = SUMX(SessionBookings, RELATED( SessionTypes[SessionLength] ) )