Forum Discussion

Matthias93's avatar
Matthias93
Helper III
8 years ago
Solved

Multiplying a column based on slicer

Hi,   I have a data model where I have a day in the year and a certain utlization in one table. For example Day 1 = 0.4, Day 2 = 0.6. Now I also have a table which lists values between 1 and 15. I ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Matthias93,

    The value of Day 2 should be 2.4(4*0.6), right? If so, I make a test in the following sample tables.




    Create the following measure in the first table.

    multiplyMeasure = MAX(Table2[Column1])*MAX(Table1[Column1])


    Create a table visual and  test the slicer.


    Regards,
    Lydia

  • Matthias93's avatar
    Matthias93
    8 years ago

    Hi Lydia,

     

    This is exactly what I needed for my dashboard. Thanks for your quick help, I'll try to apply it to my case now.

     

    Kind regards,

    Matthias

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Matthias93,

The value of Day 2 should be 2.4(4*0.6), right? If so, I make a test in the following sample tables.




Create the following measure in the first table.

multiplyMeasure = MAX(Table2[Column1])*MAX(Table1[Column1])


Create a table visual and  test the slicer.


Regards,
Lydia

juan-botero's avatar
juan-botero
Regular Visitor
8 years ago

Hello Lydia!

 

Your solution worked great, but I was wondering if your solution also applies when using 2 slicers. What I mean is to first choose an option of multiplier, and then choosing a second option to again multiply the total amount from the previous operation.

 

Thanks!

 

Juan