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'm trying to convert blank values in my matrix to Zero's. The table looks as follows:
I tried to create another measure as
Solved! Go to Solution.
Adding +0 to the end of your measure is one quick way to fix this
Forecast = CALCULATE(DISTINCTCOUNT(Task[UniqueTaskID]))+0
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Adding +0 to the end of your measure is one quick way to fix this
Forecast = CALCULATE(DISTINCTCOUNT(Task[UniqueTaskID]))+0
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@dmbd1904 - Generally that is:
Measure =
VAR __Calc = <some calculation>
RETURN
IF(ISBLANK(__Calc),0,__Calc)
Hi @Greg_Deckler , i tried that and got the same problem. See the image in my reply (It wouldn't let me include in the original post)
@dmbd1904 - Try
Measure =
VAR __Calc = <some calculation>
RETURN
IF(__Calc<0,0,__Calc)
No unfortunately that didn't work either
@dmbd1904 Can you post sample data as text that replicates this issue so I can mock it up?
@dmbd1904 , typically this creates a left join and you start getting all values.
Hi @amitchandak , I'm not sure I understand but is that what's causing the problem? Is there anyway to avoid the problem?
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |