Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Matthias93
Helper III
Helper III

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 have put this table in a slicer with 15 different options. 

 

Is it possible to now multiply my utilization by the number selected in my slicer i.e.:

 

Slicer selection = 4

Day 1 = 1.6

Day 2 = 3.2

 

I'm not sure if this is possible or not?

 

Kind regards,

Matthias

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

@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.
1.0.JPG

1.1.JPG

Create the following measure in the first table.

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


Create a table visual and  test the slicer.
1.JPG

Regards,
Lydia

View solution in original post

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

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

@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.
1.0.JPG

1.1.JPG

Create the following measure in the first table.

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


Create a table visual and  test the slicer.
1.JPG

Regards,
Lydia

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

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
Not applicable

@Matthias93,

If the above reply solves your issue, please accept my reply as answer to close this thread.

Regards,
Lydia

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 have put this table in a slicer with 15 different options. 

 

Is it possible to now multiply my utilization by the number selected in my slicer i.e.:

 

Slicer selection = 4

Day 1 = 1.6

Day 2 = 3.2

 

I'm not sure if this is possible or not?

 

Kind regards,

Matthias

@Matthias93

 

You can use the SELECTEDVALUE function

 

SelectedVALUE(SlicerTableName[SlicerColumnName]) should give you the value selected in the slicer,,, then you can multiply it with any other MEASURE

 

However you can not use it in a calculated column

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.