Show all the 'Word'

[NickProp28]

Dear Community,

I would like to have a DAX that show all the Transaction Number and Job Number if JobInvoiceNumber is blank.

[Anonymous]

Hi @NickProp28 -

Can you try this:

NewInvoiceNo = IF(SELECTEDVALUE('Table'[InvoiceNo]) = "", CONCATENATE(SELECTEDVALUE('Table'[TxnNumber]),SELECTEDVALUE('Table'[JobNumber])), SELECTEDVALUE('Table'[InvoiceNo]))

Hope this helps.

Cheers,

-Namish B 

[NickProp28]

Dear @Anonymous ,

Thank you. But here is the expected outcome Im looking for.

Thats only show transactionNumber and JobNumber when the condition is blank in JobInvoiceNumber.

[Anonymous · Accepted solution]

Hi @NickProp28 - Sorry, Not sure if i understood this correctly but if you want to just show the rows which have JobInvoiceNumber as blank, you dont need to write DAX.

It can be done using Filter on this Visual/Filter on this page pane.

Just select the InvoiceNo to blank and it will show you only 2 rows. Example as below:

Is this you are looking for?If not please explain further.

Cheers,

-Namish B

[amitchandak]

@NickProp28 , put a visual level filter JobInvoiceNumber  is Blank

or have one or all measure isblank filter

calculate(countrows(Table), filter(Table, isblank(Table[JobInvoiceNumber])))

[NickProp28]

Dear @amitchandak ,

Thanks for your response. Its work when i filter blank in visual level. But Im not get your idea about the DAX. I tried it and return nothing. Can please explain more to me?