cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KadaKuberKumar
Helper I
Helper I

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 @KadaKuberKumar ,

 

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 @KadaKuberKumar ,

 

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

parry2k
Super User III
Super User III

@KadaKuberKumar did you checked the measure I provided?






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 III
Super User III

@KadaKuberKumar 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.






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 III
Super User III

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 ?

Hi @lbendlin 

 

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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors