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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Need Help with DAX

Hi Power BI Community,

 

I need help in writing DAX for the below scenario, please find image attached.

 

Capture.PNG

 

I have 3 Columns, Customer, brand and Value.

 

If I select any slicer from Customer Column the % Share should be calculated wrt to the parent Customer.

 

That is if if only L and M are selected it should be 10/30 and 20/30

But if only L and N are selected it should be 10/10 and 30/30.

 

Please help, thanks in advance.

1 ACCEPTED SOLUTION
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

Create a measure as below:

 

Measure = 
var _num=SUM('Table'[Value])
var _deno=CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Customer ]=MAX('Table'[Customer ])))
Return
DIVIDE(_num,_deno)

 

And you will see:

vkellymsft_0-1624344879849.pngvkellymsft_1-1624344890503.png

vkellymsft_2-1624344898186.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

View solution in original post

5 REPLIES 5
v-kelly-msft
Community Support
Community Support

Hi @Anonymous ,

 

Create a measure as below:

 

Measure = 
var _num=SUM('Table'[Value])
var _deno=CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),'Table'[Customer ]=MAX('Table'[Customer ])))
Return
DIVIDE(_num,_deno)

 

And you will see:

vkellymsft_0-1624344879849.pngvkellymsft_1-1624344890503.png

vkellymsft_2-1624344898186.png

For the related .pbix file,pls see attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

 

parry2k
Super User
Super User

@Anonymous did you checked the measure I provided?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@Anonymous Try these measure:

 

Sum Value = SUM ( 'Table'[Value] ) 

% = DIVIDE ( [Sum Value], CALCULATE ( [Sum Value], ALLSELECTED ( 'Table'[Brand] ) ) )

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

lbendlin
Super User
Super User

Please define "parent Customer"  - is that the brand?

 

Are you saying 10/10 and 30/30 because the customers are different between brands L and N ?

Anonymous
Not applicable

Hi @lbendlin 

 

I'm saying 10/10 and 30/30 because the customer name is different.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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