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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Issues with measures and columns

Hi,

 

I am trying to do something in Power BI and cannot figure nout how to do it in a measure but can in a column but the column is not providing me with the full picture I am looking for. I need to take a quantity value, then multiply that number by a slicer selected value that is in .25% intervals. I want to then take the new quantity values and multipy each line item by an inputed value that deal with months and "cuts". Is there a way I can do this in one measure in order to put the new amounts in tables, visuals, ETC. Here are some SS of what I am working with.

Pic1BIForum.pngPic2BIForum.pngPic3BIForum.png

3 REPLIES 3
Anonymous
Not applicable

Hi @Anonymous ,

Based on my testing, please try the following methods:

1.Create the sample tables.

vjiewumsft_0-1722584684507.png

vjiewumsft_3-1722584813498.png

 

2.Drag the value into the slicer visual.

vjiewumsft_1-1722584699443.png

 

3.Create the new measure to calculate values.

New values = 
var _slicer = SELECTEDVALUE('Table 2'[Value])
var _adjust = SUMX(
    'Table',
    'Table'[Quantity] * _slicer
)
var result = SUMX('Table pric', 'Table pric'[Price] * _adjust)
RETURN
result

4.The result is shown below.

vjiewumsft_2-1722584741002.png

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous
Not applicable

would like ((Old Quantity)*(Selected change))*(Entered price in excel) Basically an index match match but that does not seem to be a thing.

Anonymous
Not applicable

Hi,

Do I have the create the price table because I do not think it will work as a major part of my whole project is the entered in prices in the EXCEL file.

Thanks!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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