Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there!
Is it possible to replace the following "no number" value with a zero?
I am using this DAX formula in the measure (third column)
Solved! Go to Solution.
@MRensenSDR You can resolve this I think with using the DIVIDE DAX funciton:
Gemiddeld gecalculeerd uurloon =
SUMX (
'Projectenbeheer',
DIVIDE (
'Projectenbeheer'[Kosten gecalculeerde uren],
'Projectenbeheer'[Aantal uur gecalculeerd],
0
)
)
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
HI,
Instead of '/' sign you can use DIVIDE function which handles 0 divider out of the box
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
Try it with a DIVIDE and 0 for the 3rd condition.
Gemiddeld gecalculeerd uurloon =
SUMX (
'Projectenbeheer',
DIVIDE (
'Projectenbeheer'[Kosten gecalculeerde uren],
'Projectenbeheer'[Aantal uur gecalculeerd],
0
)
)
Thanks for all the quick replies! I should've known this... Thanks for all the quick help!
Try it with a DIVIDE and 0 for the 3rd condition.
Gemiddeld gecalculeerd uurloon =
SUMX (
'Projectenbeheer',
DIVIDE (
'Projectenbeheer'[Kosten gecalculeerde uren],
'Projectenbeheer'[Aantal uur gecalculeerd],
0
)
)
HI,
Instead of '/' sign you can use DIVIDE function which handles 0 divider out of the box
Thanks,
Sayali
If this post helps, then please consider Accept it as the solution to help others find it more quickly.
Proud to be a Super User!
@MRensenSDR You can resolve this I think with using the DIVIDE DAX funciton:
Gemiddeld gecalculeerd uurloon =
SUMX (
'Projectenbeheer',
DIVIDE (
'Projectenbeheer'[Kosten gecalculeerde uren],
'Projectenbeheer'[Aantal uur gecalculeerd],
0
)
)
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/