undefined

[Anonymous]

Create a Measure to calculate the "Job Duration" from the Job table, Job Duration is the difference of Job start time & job end time . Compare this calculated value with job real duration column in Job Table if the value is not matching use the measure you calculated for all the visuals

[v-chenwuz-msft]

Hi @Anonymous ,

measure =
VAR _start =
    SELECTEDVALUE( 'table'[start time] )
VAR _end =
    SELECTEDVALUE( 'table'[end time] )
VAR _duration = _end - _start
RETURN
    IF( _duration = SELECTEDVALUE( 'table'[real] ), TRUE(), FALSE() )

Please share some sample data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11]

HI @Anonymous ,

Can you share more details here please. refer below:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Thanks,

Pragati