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])
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])