Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

IF ISBLANK Optimization

Hello everyone! I'm wondering if my current solution is really the best solution. Maybe someone else can provide some feedback on that measure. I have a simple transaction table with the following ...
Need Help
  • daxer-almighty's avatar
    daxer-almighty
    5 years ago

    joshua1990 

     

    Mate, all you need is this formula (and it's faster for obvious reasons):

    Ratio =
    DIVIDE (
        SUM ( Sales[Quantity] ),
        SUM ( Sales[Value] )
    )
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, joshua1990 

please correct me if I wrongly understood your question.

Please try the below.

 

 

Ratio 2 =
COALESCE (
DIVIDE ( SUM ( 'Table'[Quantity] ), SUM ( 'Table'[Value] ), "" ),
""
)

 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: https://www.linkedin.com/in/jihwankim1975/

 

  • joshua1990's avatar
    joshua1990
    Icon for Post Prodigy rankPost Prodigy
    5 years ago

    Thanks, but why would you say your measure works better? What is the advantage here?