Forum Discussion
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...
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 GeraldesSeems to be related to the tables, relationships and dates
That still gives me the same result
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)
This is giving me all results as over 100%
Not sure what the issue could be