Forum Discussion

sraj's avatar
sraj
Icon for Responsive Resident rankResponsive Resident
6 years ago
Solved

Blank card without selection

Hi,
 
Can someone please help?  I am using the below measure to get the value if it first is selected, is it possible to use an 'or'in here?  For eg either First name or
last name is selected?
 
Filing Status = IF(HASONEVALUE(kro_EMP_TAXPROPERTIES[FirstName]), MIN(kro_EMP_TAXPROPERTIES[FilingStatus]), "" )
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    sraj try this

     

    Filing Status = IF(HASONEVALUE(kro_EMP_TAXPROPERTIES[FirstName]) || HASONEVALUE(kro_EMP_TAXPROPERTIES[LastName]), MIN(kro_EMP_TAXPROPERTIES[FilingStatus]), "" )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    6 years ago

    sraj try this

     

    Filing Status = IF(HASONEVALUE(kro_EMP_TAXPROPERTIES[FirstName]) || HASONEVALUE(kro_EMP_TAXPROPERTIES[LastName]), MIN(kro_EMP_TAXPROPERTIES[FilingStatus]), "" )

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

    • sraj's avatar
      sraj
      Icon for Responsive Resident rankResponsive Resident
      6 years ago

      This worked very well.  The website is not letting me accept this suggestion as a solution, thank you for your help!!

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        6 years ago

        sraj glad to hear. not sure why you cannot accept a solution. anyhow that is not a big deal, 

         

        I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

        ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡