Forum Discussion
Add measure to count not null values but return 0 for null values
Hi, I have a Power BI measure issue that I can use some assistance in solving. I want to count number of records within a table that are not null, however I still want records with null values to ap...
Thank you for thie reply, for my simple example, yes the "+0" solves the problem.
My appologies, I should have added that the true business case is a report based on an analytic model using multiple tables (Hundred thousand + records). Using the +0 results in a cross-join between the multi-table joins and will produce horrendous performance issues.
Thank you