Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

New mesure error DIVIDE

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's avatar
    tamerj1
    4 years ago

    Anonymous 

    By simple divide I mean something like

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

3 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi Anonymous 

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

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    By simple divide I mean something like

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you!!!!