How to display blank results in CALCULATE MAX 'TABLE'[DATES]

[CityRoamer]

Hi - I have a table of job runs that contains a column of job IDs and column of job run dates.  I created a measure that will calculate the most recent job run date for each job ID using the following calculation:

Last Run = CALCULATE(MAX('Job Run'[Run Date]))

When adding this measure as a field on a report page (which has the 'Job' data field that has the full list of jobs), it does calculate the most recent job run for each job listed on the report page if run dates exist.  However, if there are no run dates for a given job, it causes the job to hide from the report.  I'm assuming this is because there is nothing to calculate for that particular job. 

I would rather the Last Run show up as blank instead of causing the job to hide on the report.  Is there another way to do this without using IF statements, which prevents the report from loading because it runs out of memory (there are 50K jobs in the table).

[CityRoamer]

Hi - I do not have the option to 'Show items with no data':

I am assuming this is because it is a calculated field?

[v-luwang-msft]

Hi @CityRoamer ,

 Click "Job id" ,not the measure you created.And if the visual only created by measure ,it could not be used.

Best Regards

Lucien

[v-luwang-msft]

HI @CityRoamer ,

Click  show items with no data,you will see the measure even it is blank.

Output result:

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien