Creating a measure that would show the earliest message in a card visual

[Anonymous]

I have a column in a table called message list which shows a text field.

I also have a column that shows the date of each message.

[Message list] [Date]

I would like to show the earliest message in a card visual.

How can I create a measure for this please?

[v-yadongf-msft · Accepted solution]

Hi @Anonymous ,

This is my test table1:

Test table2:

Please try following DAX:

Measure = IF(
    MINX(FILTER('Table1','Table1'[Date] = MIN('Table1'[Date])),'Table1'[Message list]) = BLANK(),
    "No error",
    MINX(FILTER('Table1','Table1'[Date] = MIN('Table1'[Date])),'Table1'[Message list])
    )

The result you want:

Please refer the attached pbix file.

As for the another question "when I click on a graph it only shows the message then, otherwise it's hidden (no text in the card)", I think it's not possible.

Best regards,

Yadong Fang

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

[Anonymous]

Thank you so much for this solution! 🙂

I did find a solution to hide the visual in the webpage below, so I'll incorporate that, please feel free to have a look yourself at it if you like.

Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI

[amitchandak]

@Anonymous , Try a measure like

firstnonblankvalue(Table[Date], max(Table[Comment]))

[Anonymous]

Sorry I wasn't clear in what I wanted. May I ask if it can be tweeked as I need the earliest value even if it is blank.

Also, IF the value is blank I want it to say 'No Error' so I need the below included please 🙂

IF(
x = BLANK(),
"No Error",
x
)

I also wish to ask if this can be a filtered visual so that when I click on a graph it only shows the message then, otherwise it's hidden (no text in the card).