Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity 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...
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
Georgesunil77's avatar
Georgesunil77
Icon for Advocate II rankAdvocate 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
Icon for Super User rankSuper 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
    Icon for Advocate II rankAdvocate II
    4 years ago

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

    Really Appreciate your Support !

     

    Regards,
    George