Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 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
    5 years ago

    Anonymous 

    because denominatordenominator is 0.

    you can use DIVIDE

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

This is the part of my measure which  doesnt work

Part 1 = Calculate(SUM('Detail'[Sales New Used]),('Detail'[Sales New Used]="New")
what i need this to do is filter all the New deals and count them up for each business area to then be divided by the RE
Below is all the data required for this measure :

Business area

REGS

Sales new used

penetration

 

A

200

New

(Count of new) ‘New’/REGS

 

B

300

New

 

 

C

453

New

 

 

A

200

Used

 

 

B

234

Used

 

 

C

754

New

 

 

A

768

New

 

 



  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous I have added a sample data table

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    Anonymous 

    is this what you want?

    Column = 
CALCULATE(COUNT('Table'[Sales new used]),FILTER('Table','Table'[Business Area]=EARLIER('Table'[Business Area])&&'Table'[Sales new used]="New"))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 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