Forum Discussion
Filter Blank values in a division without using filter Panel
Hi All, I have created a DAX expression to calculate an average based on a division, my issue is to have the correct figures I need to remove from the calculation blank value, the only Solut...
Hi Fantmas if not already, check article https://www.sqlbi.com/articles/blank-handling-in-dax/ .
Keep in mind how DAX engine treat blank in functions like AVERAGE, link https://learn.microsoft.com/en-us/dax/average-function-dax .
It could be that you need to use AVERAGEX function. I hope this help.