Forum Discussion
Row with blank value disappear from table
My data model consists of three tables: a table with all sales staff a table with records of all sales a calendar table When I create a visual with all staff for a sales period Power BI retu...
Anonymous - There should be an option to show items with no data. Otherwise, you can often get around this by doing something like this:
Measure = VAR __Calc = <Some calculation> RETURN IF(ISBLANK(__Calc),0,__Calc)
Make sure that the table field is set to don't summarise, otherwise having a blank value will cause the whole row to disappear.