Forum Discussion
Power BI Blank Dax Values
Hi All,
I need to remove the rows with blank values on my table. currently I have 2 columns on my table, first column is "Group" from the account table and the 2nd Column is Amount Testing which is a DAX Measure.
Below is a screenshot of the table.
Thank you!
4 Replies
- VahidDM
Super User
Hi ClaffBilly
Turn this off on your table, Grouping column setting:
See this:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/Hi VahidDM,
"Show items with no data" is already turned off on the table, since the Group column always has a data on the PBI raw, that option would not work.
I think may issue is about the Amount Testing. I am thinking of a way where whenever the Amount Testing is blank, the row will be removed. im pulling the values in amount testing using dax from other tables.
ryan_mayu
Hi ClaffBilly ,
Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.
Best Regards,
Stephen Tao
