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

Don'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.

Reply
francoisl
Helper II
Helper II

applying a measure (percentage) to other member of a serie

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

1 ACCEPTED SOLUTION
gmsamborn
Super User
Super User

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.

gmsamborn_1-1738278325045.png

 

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)

 

 

View solution in original post

10 REPLIES 10
v-yajiewan-msft
Community Support
Community Support

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

gmsamborn
Super User
Super User

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.

gmsamborn_1-1738278325045.png

 

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. 

@francoisl 

 

I'm glad it worked for you.

francoisl
Helper II
Helper II

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

Gabry
Super User
Super User

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!

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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