Forum Discussion

NickProp28's avatar
NickProp28
Icon for Post Partisan rankPost Partisan
5 years ago
Solved

Show all the 'Word'

Dear Community,

 

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

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

     

     

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      NickProp28
      Icon for Post Partisan rankPost Partisan
      5 years ago

      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? 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      NickProp28
      Icon for Post Partisan rankPost Partisan
      5 years ago

      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's avatar
        Anonymous
        Not applicable
        5 years ago

        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