Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
One of the measure gives output in the range of -800000 to +900000 range.
I need to remove all those values from a measure's output which start eaither -0. or 0.
please suggest how to remove them.
Thanks
@mypowerbi1 Try to use the following dax if it works for you:
= CALCULATE (
<measure>,
FILTER (
ALL ( <table> ),
LEFT ( <measure>, 2 ) <> "-0" && LEFT ( <measure>, 1 ) <> "0"
)
)
If you find this insightful, please provide a Kudo and accept this as a solution.
try this
IF( ABS([MEASURE])>= 1 ,[MEASURE])
try this
IF( ABS([MEASURE])>= 1 ,[MEASURE])
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |