Show items with no data Paginated Report

nkasdali 

You can add +0 to your measure though it has some performance impact.

How about if you select "Show Item with No Data" ?

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

Hello, is there any more information available on this topic? We are running into the same issue.

Hi All,

I've got the solution.

The key to this problem is learning how to add the "ADDMISSINGITEMS" dax function to your dataset query on Paginated Reports builder.

Steps:

1. Open your paginated report, connect it to your database source and create a new dataset by selecting your columns and parameters, as usual.

2. After you have done that and your dataset query has been generated, you need to edit it by manually adding the "ADDMISSINGITEMS()" dax function to your "SUMMARIZECOLUMNS" function that has been generated automatically. You can find many videos and explanations on the internet on how to use the ADDMISSINGITEMS function.

3. (short explanation about the function) Add to the ADDMISSINGITEMS function the columns you would like to retrieve items with no data as a first argument, then paste your SUMMIRIZECOLUMNS function as a second argument, and finally add all the columns you selected in your initial query as a third argument (all those which are not measures). And magic, the problem has been solved.

Lastly, in case it helps a bit further, this is a way you can look at your new query in very rough terms:

EVALUATE ADDMISSINGITEMS(columns_to_show_null_values, SUMMIRIZECOLUMNS(....), columns_selected_in_your_query)

Best wishes.