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

this is what i want 

 

Business Area

REGS

Sales New used

Pen

 

 

 

A

968

2

2/968=0.002
x 100 = 0.2%

 

 

 

B

300

1

 

 

 

 

C

1207

2

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • 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