Measure Displaying Blank Value

[DominicWest]

Hi,

I have noticed that there are a fair few solutions on how to return 0 instead of blank but the issue I am having is that I am creating a new measure to filter the same set of data and calculate off of these.

When I create the below forumla it returns blank value when the data exists.

Measure = CALCULATE(SUM(TABLE[ITEM ID]))

Thanks for the help.

[v-qiuyu-msft]

Hi @DominicWest,

Is there any slicer or filter in the report? Would you please share the pbix file with us (Don't share sensitive data) ? 

Best Regards,
Qiuyun Yu

[DominicWest]

Hi @v-qiuyu-msft

Thanks for the help, how do I remove the sensitive data whilst maintaining the structure of the report for you to see?

Kind regards

Dominic