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

Hi Anonymous ,

 

Might because of the denominator. Try:

penetration = divide(CALCULATE(sum(Detail[Sales New Used]),Detail[Sales New Used]="New"),Calculate(SUM('Dealer Summary'[Regs]),All('Dealer Summary'))

 If it doesn't work, please show some sample data and expected result.

 

Best Regards,

Jay