Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX help

why does this measure not work?     penetration = divide(CALCULATE(sum(Detail[Sales New Used]),Detail[Sales New Used]="New"),SUM('Dealer Summary'[Regs]))   sales new used needs to be divided by...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    Anonymous 

    because denominatordenominator is 0.

    you can use DIVIDE

    Result = DIVIDE([count],[Regs2])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Why am i getting infinity and values over 100%

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    Anonymous 

    I suggest you check regs and count. You mean the business area have the results for regs and count, but result is infinity?

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      yes 

       

      • ryan_mayu's avatar
        ryan_mayu
        Super User
        4 years ago

        Anonymous 

        because denominatordenominator is 0.

        you can use DIVIDE

        Result = DIVIDE([count],[Regs2])