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)
Greg_Deckler
Community Champion
Community ChampionAnonymous - 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)Thanks Greg_Deckler, your answer worked like a charm.