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 ,
I am using below measures to get the result :
Hi @Priya2007
Try by using the filter pane like this:
Hi @Priya2007 ,
I editted my previous answer because it was lacking a "-" in front of the 0.01 in the "is less than" part of the filter. Sorry for the typo.
The way to get rid of the zeros (floating point issue) using the filter pane would be like this:
Regards,
Write is not 0.00
OR
use basic filtering and select all except 0.00
Hi,
It is a measure, I cant find basic filtering in that .
write 0.00 in place 0 at advanced filter
Hi , I have tried that , but thats not working .
@Priya2007 add a IF out of your code,like
WIP=VAR _Total= SUMX(SUMMARIZE(Transactions, Transactions[PROJECT_NO], Transactions[FISCAL_PERIOD]),[WIP Amount]) RETURN IF(_Total<>0,_Total)
if this still not work, it might be some very small value, like 0.000000001, which come from the floating-point calculation
Hi Daniel,
I have tried but it is not working
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |