Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi all,
I have an issue where I have the following data :
Column A Total Sales Total Transporation Percentage (Measure)
Carrier 1 10000 1000 10%
Carrier 2 20000 1800 9%
Carrier 3 23000 2400 10,43%
However for comparison I want to keep the Carrier 2 percentage (measure) and apply it to Carrier 1 and Carrier 3.
Chatgpt and Copilor where not really helpfull.
Also I need to be able to filter by product line with the percentage getting adjusted.
Can you help finding the best way to do this ?
THanks
F
Solved! Go to Solution.
Hi @francoisl
I'm a little unclear about your expected results and how it will be used. I'm wondering if the following would help.
I created a disconnected 'Carrier' table for use in a slicer.
Then I added the following measures. (I did it by steps because I wasn't sure which measures you would want to display).
Sales = SUM( 'Table'[Total Sales] )
Transport = SUM( 'Table'[Total Transportation] )
Original Rate = DIVIDE( [Transport], [Sales] )
Selected Rate =
CALCULATE(
DIVIDE( [Transport], [Sales] ),
'Table'[Column A] = SELECTEDVALUE( 'Carrier'[Carrier] )
)
New Transport = [Sales] * [SelRate]
Change = [New Transport] - [Transport]
Pct Chg = DIVIDE( [Change], [Transport] )
These are my results.
applying a measure (percentage) to other member of a series.pbix
I hope I understood your requirements. (probably not)
If not, please show your expected results and how you would use it (matrix, card, etc)
Hi @francoisl , hello gmsamborn and Gabry, thank you for your prompt reply!
Is there any progress on this issue?
If you find any answer is helpful to you, please remember to accept it.
It will help others who meet the similar question in this forum.
If you have any further related issues, please feel free to reply!
HI,
I was off thursday and friday. And this is only one of my project. I will get back to you all by tomorrow.
Thanks
F
Hi @francoisl
I'm a little unclear about your expected results and how it will be used. I'm wondering if the following would help.
I created a disconnected 'Carrier' table for use in a slicer.
Then I added the following measures. (I did it by steps because I wasn't sure which measures you would want to display).
Sales = SUM( 'Table'[Total Sales] )
Transport = SUM( 'Table'[Total Transportation] )
Original Rate = DIVIDE( [Transport], [Sales] )
Selected Rate =
CALCULATE(
DIVIDE( [Transport], [Sales] ),
'Table'[Column A] = SELECTEDVALUE( 'Carrier'[Carrier] )
)
New Transport = [Sales] * [SelRate]
Change = [New Transport] - [Transport]
Pct Chg = DIVIDE( [Change], [Transport] )
These are my results.
applying a measure (percentage) to other member of a series.pbix
I hope I understood your requirements. (probably not)
If not, please show your expected results and how you would use it (matrix, card, etc)
Awsome... This is the first time I create an unconnected table to make a selection this way. Many thanks.
I want to re-use the percentage of Carrier 1 and apply it to the other carriers. This means that I want to compare and calculate potential economy to other Carriers. Does that make sense ? Ex : Since carrier 2 is 9% I want to apply the 9 % to the sales gone through carrier 1 and 3 and then substract the $$ amount.
Not sure,
if you want a measure that calculate the percentage of carrier1 you just need to make it like this:
Carrier1percentage= calculate(divide(sum(trasnport),sum(sales)), columna="Carrier1")
this will always calculate the percentage of carrier1
Hello @francoisl ,
I don't understand what you want to do.
Do you want to display for every row the percentage of carrier 2?
Yes, I want to show and apply the rate on every row.
Hi @francoisl ,
Thank you for your feedback.
Could you please review the reply from gmsamborn?
If this is not feasible for you, please feel free to reply!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |