New mesure error DIVIDE

[Anonymous]

Hello

Maybe is a noob question, but I'm using a star model like this to create a table, and now I need to divide two values of different tables that are not related directly. And I don't know what kind of formula to use.

I know that I can't use RELATED, there is a way to do this keeping my model.

by id [ (rejects)/(production) ] * 100

[tamerj1 · Accepted solution]

@Anonymous 

By simple divide I mean something like

DIVIDE (SUM (Rejects[Rejects]), SUM (Production[Production]))

[Anonymous]

Thank you!!!!

[tamerj1]

Hi @Anonymous 

a simple DIVIDE should work but in the table visual you need to use the id from the Rejects or User Tables