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.
Good Morning Community,
I have an easy one where a matrix I have created, shows the standard deviation of days difference in accordance with their "on-time" measure. Meaning that if the value is >3 then it is considered late, <-4 it is considered early, and in between is considered on-time. Here in the matrix though there are blanks for months as well as zeros. I was wondering what the difference between the two is? Is there a reason that both zeros and blanks are in the matrix instead of just one or the other? Thank you as always!
the 0.00 will probably be where you have values but they are 0 and the blank is where there is no value, you can change the blank to 0 with a
if(isblank(value),0, value)
Proud to be a Super User!
Hi @Anonymous ,
Based on the description you have given:
If still have question, try posting your calculations and some smaple data.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Your source data has blanks. Not sure about the zeros. It either has zeros, or it has numbers that add up to zero.
Blanks and zeros are very different animals for DAX. My advice is 99.9% of the time, you do not want blanks in any of your values unless you are specifically looking for them and want to handle them in DAX. If you want to get rid of them, click on the column in Power Query, click on the Transformation tab, then Replace Values. Type null in the search for field and 0 in the replace with.
Read this for more info on how Blanks work and how to handle if you bring them into DAX.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting@Anonymous these are two different things, I believe whatever measure you are using, somewhere it has the value in the cell, maybe zero and that is adding up to showing the zero whereas in other cases there are no rows, and get the blank value
read more here.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |