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

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