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
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |