Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, new to the group and PBI, this will be basic for a lot of you, I have a measure - "Hourly Average = DIVIDE([Inducted],[Hour Runtime],0)". I want this to return a the value only if another measure [Sorted] is greater than 50. Any help will be appreciated - thanks in advance, Daniel
Solved! Go to Solution.
Hi @Anonymous
Try this
Hourly Average = IF(Sorted > 50, DIVIDE([Inducted],[Hour Runtime],0), "")
regards
Phil
Proud to be a Super User!
Thankyou!
Hi @Anonymous
Try this
Hourly Average = IF(Sorted > 50, DIVIDE([Inducted],[Hour Runtime],0), "")
regards
Phil
Proud to be a Super User!
Hi @Anonymous
You can create a measure with below code:-
Hourly Average =
VAR result =
DIVIDE ( [Inducted], [Hour Runtime], 0 )
RETURN
IF ( [sorted] > 50, result, BLANK () )
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin