Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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
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
@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
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
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |