How to Display Items with No Data in a SSAS Tabular Model

Description:

In this example we explain that how to display items with no data in Tabular Model in SSAS.or how to display items with no data in SSAS tabular measures. Or show all member of dimension even when measure doesn’t exist for that member in SSAS.or including all dimension table rows even if no Fact Table entries in SSAS tabular model.

Here we demonstrate that how to handle Blank in DAX in SSAS Tabular Model.

Below is the example of how to display items or record of the table even if there is no data for particular measure in SSAS Tabular Model.

Measure:

Sum of TotalDue:=IF(ISBLANK(SUM(SalesOrderHeader[TotalDue])),0,SUM(SalesOrderHeader[TotalDue]))