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] )
    )
daxer-almighty's avatar
daxer-almighty
Icon for Solution Sage rankSolution Sage
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] )
    )