Forum Discussion
Need help on tool tip - Pareto Analyis
Hi Team,
I need help on concatenatex in the Dax expression. Please find the below Clustered Column chart's tool tip.
Help me on the below,
1. Need Distinct values. The values are repeating ex : P4,P4 in the second bar.
2. Single value should appear on 4th & 5th bar. now its showing P2, P5 on both bars.
Details (Pareto analysis) : The data is simplified, it has Brand, Product, GMV value. Based on GMV value the Share after filteres applied needs to be calculated. The cut-off is 80% to be labelled as Power Product/ not amongst the selections. On labeling the product either as Power/not the Stock status count is required as below but the tool tip is not correct.
Sample PBIX file attached.
https://drive.google.com/file/d/1nHRLqw13pXKVHSr1QI2urk-BWq6D9XF1/view?usp=drivesdk
Regards,
Arjun DN
Welcome,
I just followed the steps on :
https://www.daxpatterns.com/abc-classification-dynamic/
They have a great explanation there. In case you find it difficult to understand I suggest to look at the file I created for you to see how your data relates to the explanation.
I kindly ask you to mark my answer as the solution. A thumbs up for the effort is appreciated. Many thanks!
10 Replies
- stevedep
Memorable Member
Hi,
The download link is not working?
- stevedep
Can you help me a bit more on this one?
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490- stevedep
This should be what you are looking for:
ConCatX_Prd = var __sumtbl = SUMMARIZE(Table_Measure;Table_Measure[Product]) return CONCATENATEX(__sumtbl;[Product];",")Please mark as solution if it works for you, thumbs up for the effort appreciated.
Kind regards, Steve.