Dax Help

[Anonymous]

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%

[goncalogeraldes · Accepted solution]

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

[Kumail]

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

[goncalogeraldes · Accepted solution]

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 · Accepted solution]

Seems to be related to the tables, relationships and dates

[Anonymous]

That still gives me the same result

[goncalogeraldes]

@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]

This is giving me all results as over 100%

Not sure what the issue could be