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 swi...
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

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

Seems to be related to the tables, relationships and dates