Thanks for Picking my query:
I've got the duration in HH:MM:SS format in Power Query with below query. but unable to calculation on Matrix Visual, However it given result in Power query.
HH:MM:SS - Resolution time (hrs) New =
VAR MTTR = 'Task Acceptance P1-P2-P3-P4'[Resolution time (hrs) New]
VAR Hours = TRUNC ( MTTR )
VAR MinSec = FORMAT ( MAX ( MTTR - Hours, 0 ) / 24, ":nn:ss" )
IF ( NOT ISBLANK ( MTTR ), Hours & MinSec )
it is taking zero in Matrix Visual.