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

[francoisl]

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

[Anonymous]

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!

[francoisl]

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 · Accepted 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)

[francoisl]

Awsome... This is the first time I create an unconnected table to make a selection this way.  Many thanks. 

[gmsamborn]

@francoisl 

I'm glad it worked for you.

[francoisl]

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.  

[Gabry]

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]

Hello @francoisl ,

I don't understand what you want to do.

Do you want to display for every row the percentage of carrier 2?

[francoisl]

Yes, I want to show and apply the rate on every row. 

[Anonymous]

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!