Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |