Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Make a divition table with only parameters

Hello!

 

I'm trying to make a multiplication table (In fact is a divistion table) with parameters without using any dataset in Power Bi.

 

The result variable is calculated by the DAX formula below:

 

Result = divide([Numerator Value]; [Denominator Value])

But I can only see the division by itself.

 

 

You can download the report here

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi joaco,
    I didn't understand your logic... to use DIVIDE to show MULTIPLICATION.
    Divide a number by itself always will be 1.

     

     

    Multiplication = Numerator[Numerator Value] * Denominator[Denominator Value]

    Use Multiplication measure instead of Result measure.

     

    Tell us if works for you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      Hello! I did it, the problem it's the same: https://files.fm/u/q84zdpjd

       

      Because the problem it's not the logic.

       

      The problem is actually that the parameter didn't return a value.