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 

maybe you can try to saparate the DAX to two parts and check which part didn't return the expected result.

CALCULATE(sum(Detail[Sales New Used]),Detail[Sales New Used]="New")

SUM('Dealer Summary'[Regs])