topic Re: applying a measure (percentage) to other member of a serie in DAX Commands and Tips

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

francoisl — Thu, 30 Jan 2025 15:05:52 GMT

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

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

Gabry — Thu, 30 Jan 2025 19:43:38 GMT

Hello francoisl ,

I don't understand what you want to do.

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

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

francoisl — Thu, 30 Jan 2025 20:09:52 GMT

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.

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

Gabry — Thu, 30 Jan 2025 20:49:17 GMT

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

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

gmsamborn — Thu, 30 Jan 2025 23:31:49 GMT

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)

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

Anonymous — Mon, 03 Feb 2025 07:31:34 GMT

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!

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

francoisl — Mon, 03 Feb 2025 13:06:27 GMT

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

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

francoisl — Mon, 03 Feb 2025 21:00:14 GMT

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

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

Anonymous — Tue, 04 Feb 2025 01:26:16 GMT

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!

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

francoisl — Tue, 04 Feb 2025 15:29:01 GMT

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

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

gmsamborn — Tue, 04 Feb 2025 21:58:40 GMT

francoisl

I'm glad it worked for you.