how to calculate collective performance of multiple accounts of sales and target for single customer
Hi Experts, I wants to calculate a column or dax measure for to calculate group of dealers sales and target, in my working one dealer / customer has multiple accounts in which they are invoicing and singned targets, i wants to calculate their collective sales in next column and collective target in next column and then to calculate their achievmeent % agaisnt collective targets and sales and if dealers has only one account then measure shows only his single accounts sales and target in next columns but if have multiple accounts the shows collectively. But i have thousands and customer and rows database based on this type of challenge. I have done this in excel file (File is attached) but how to do in Power BI with caculated column or dax measure please guide. In excel i am doing this like: M/s Afzal has 11 accounts in which they are invoicing and has singed their targets accross the countary, i assigned Group name "AFZAL" in column 1 to every ID, then in next column mentions "G" against every group name (Column 2) and then mention "H" head of all accounts in next column (Column 3). Now the formula works as it combine all "Afzal" named sales or target against "H" in seperated columns called individual total target or sales after grouping. Excel sampling picture .... reference file of excel and pbix is also attacehd in one drive: https://drive.google.com/file/d/1TnJK8-PnseCsouKwotBEGWpVYinDFwmG/view?usp=sharingHow can insert slab in Matrix Slab
Hi Experts, Below is the calculated column Measure, can i insert this type of slab in matirx row. i want to show slab wise sales and tagts. AchievementSlab = SWITCH( TRUE(), 'Signed Target or MOU'[YTD Ach % REF] >= 0.01 && 'Signed Target or MOU'[YTD Ach % REF] < 0.10, "1%~9%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.10 && 'Signed Target or MOU'[YTD Ach % REF] < 0.20, "10%~19%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.20 && 'Signed Target or MOU'[YTD Ach % REF] < 0.26, "20%~25%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.26 && 'Signed Target or MOU'[YTD Ach % REF] < 0.41, "26%~40%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.41 && 'Signed Target or MOU'[YTD Ach % REF] < 0.51, "41%~50%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.51 && 'Signed Target or MOU'[YTD Ach % REF] < 0.76, "51%~75%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.76 && 'Signed Target or MOU'[YTD Ach % REF] < 0.86, "76%~85%", 'Signed Target or MOU'[YTD Ach % REF] >= 0.86 && 'Signed Target or MOU'[YTD Ach % REF] < 1, "86%~99%", 'Signed Target or MOU'[YTD Ach % REF] >= 1, "100% Above", "Unknown" )
Need Help With Dax Table Query
I have the below Dax measure that produces a list of parent suppliers with the sum of the spend on them from a fact table. Parent Supl Spend = var parents = SUMMARIZE('Export','Export'[ParentSupplierName],'Export'[LeaderName],"Spend",SUM('Export'[Spend Amount])) Return parents The lines returned from one supplier look like this: I would like to extract from this output ONLY the line with the GREATEST spend. How would I do that? Mark Janecek PTP Metrics Analyst Johnson Controls
Calculating share of sales of specific product
Hi, I am trying to create a DAX calculation which will display a share of a product on another product flagged as market leader. Basically, this is it: Products are filtered based on slicers/categories but it is not a problem. I could calculate the % based on column total, but closest I got in this time was here - values are calculated only for Market Leader. I use this DAX: =DIVIDE( SUM (T_DATA[Value]); CALCULATE( SUM (T_DATA[Value]); T_DATA[T_LOV_Product.Competition]=2; ALLSELECTED(T_LOV_Product) )) Thank you very much indeed. Jan
