Showing Filtered Values and Blanks

[Otto_Luvpuppy]

Hi, I'm pretty sure I'm doing something stupid here but can't figure it out.

I have a table that has a Status Column. I have another table, related through ID, that has the Status and the Date that specific Status was modified. All I want to do is to create a new measure that gives me the latest modified date inrelation to a specific status and give me blanks on the lines that don't have that specific status. At the moment the following code is giving me the date but only showing me the lines where the status is met. Any ideas? What am I missing please? I think my first MAX function might be screwing things up but I can't find a way to have only '(x) Change Control - Full'[Status])="Submitted", I need to surraound it with something.

If(MAX('(x) Change Control - Full'[Status])="Submitted",Calculate(MAX('(x) Change Control - Status Log'[Modified])),BLANK())

[v-yangliu-msft · Accepted solution]

Hi  @Otto_Luvpuppy ,

I created some data:

When the value is blank, Power BI automatically hides the value that is blank:：

The first method:

You can check [status] – Show items with no data.

A blank value is then displayed：

The second method:

You can create a Measure and replace Blank with 0.

Create measure：

Measure 2 =
IF(
    [Measure] = BLANK() ,0,[Measure])

If you need pbix, please click here.

Showing Filtered Values and Blanks.pbix

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Otto_Luvpuppy]

Hi...thanks for the reply. I already had the 1st method on and funnily enough I'd plugged the second method in shortly after I posted this call for help.....that seems to work.

Thanks again

[lbendlin]

Learn about the "Show items with no data" feature.  

If you like more help, please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523