Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dax Help

penn = Divide (Sumx('Detail',[new unit]), SUM( 'Dealer Summary'[Regs]))
 
This formula should be dividing the REG by the UNITS
 
example :
Unit 261 
Reg 155 
= 0.59
=59%
 
However, when switching the formula it doesnt work to get that answer instead its giving me 168%
Need Help
Show and Tell
  • goncalogeraldes's avatar
    goncalogeraldes
    4 years ago

    Hello there Anonymous ! DO you need the SUMX() in the formula or does a SUM() work? Try and see if this works:

    penn = 
var _newunit = SUM('Detail'[new unit])
var _regs = SUM( 'Dealer Summary'[Regs])

return
Divide ( _newunit, _regs )

     Hope this answer solves your problem! If you need any additional help please tag me in your reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
    Thanks!

    Best regards,
    Gonçalo Geraldes

  • Anonymous's avatar
    Anonymous
    4 years ago

    Seems to be related to the tables, relationships and dates

6 Replies

  • goncalogeraldes's avatar
    goncalogeraldes
    Super User
    4 years ago

    Hello there Anonymous ! DO you need the SUMX() in the formula or does a SUM() work? Try and see if this works:

    penn = 
var _newunit = SUM('Detail'[new unit])
var _regs = SUM( 'Dealer Summary'[Regs])

return
Divide ( _newunit, _regs )

     Hope this answer solves your problem! If you need any additional help please tag me in your reply.
    If my reply provided you with a solution, pleased mark it as a solution ✔️ or give it a kudoe 👍
    Thanks!

    Best regards,
    Gonçalo Geraldes

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      That still gives me the same result

      • goncalogeraldes's avatar
        goncalogeraldes
        Super User
        4 years ago

        Anonymous I think you got it backwards... Try this:

        penn = 
var _newunit = SUM('Detail'[new unit])
var _regs = SUM( 'Dealer Summary'[Regs])

return
Divide ( _regs , _newunit)

         

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Seems to be related to the tables, relationships and dates

  • Kumail's avatar
    Kumail
    Impactful Individual
    4 years ago

    Hello
    If you could send a sample .pbix that demonstrates what you are looking to get. It would really help to provide you a quick solution.
    You can send the sample .pbix file by adding it to your drive or dropbox and add the link here. 
    Regards
    Kumail Raza