Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

How to Get Your Question Answered Quickly

Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Need Help
Tips and Tricks
Georgesunil77's avatar
Georgesunil77
Advocate II
4 years ago

Thanks aton Miguel !
One more question I had, I am trying to replicate the below formula which I have in excel :
=IF(AR9="No BoM",100%, AV9/AX9)

How do we put an if conditon in Power BI for a TEXT
if AR column contains "No BoM", Then give me 100% or give me the formula AV9/AX9.

 

 

Regards,

George

  • MFelix's avatar
    MFelix
    Super User
    4 years ago

    Hi Georgesunil77 ,

     

    This depends on how you have the values but this can be something similar to:

     

    Percentage Value = IF(SELECTEDVALUE(Table[Column]) = "No BoM", 1 , Divide(SUM(Table[Column]),SUM( Table[Column]))

     

    Then just format has percentage.

    • Georgesunil77's avatar
      Georgesunil77
      Advocate II
      4 years ago

      Thanks alot Miguel !
      This worked for me... Thanks for introducing me to "SELECTEDVALUE".

      Really Appreciate your Support !

       

      Regards,
      George