Dynamic combined customer and product 8020 analysis
Hi, Im wanting to create a dynamic measure to analyse which "A" customers bought which "A" products and so on. Must be dynamic, to use the page filters I have. Analysis to spit out: 1) sum of sales for A customer purchasing A product, also AB, BA, BB, etc 2) number of customer (and products) in AA, AB, etc 3) which customers / products in AA, AB etc Data set is transaction order history, so includes customer name / code, product name / code and sale date. Can someone please help as my DAX is not at this level, assume it needs to be done in virtual tables then bringing together?
how to create the PRODUIT function in DAX
Dear all, I have been tasked to create a PowerBI dashboard, in which there is a portfolio of holdings. All fine, but one requirement: calibrate the portfolio every 15 days. I figured all out in Excel, and came quite far in PowerBI DAX. That is: up to the column "cumul calibration" as shown below. In excel it´s a plain PRODUCT function, but I have no clue how to do this in DAX. Would be great if anyone can help me out, cheersCalculating a dynamic benchmark with multiple conditions
Hi all, I am struggling with a problem and I hope you can help. My star schema looks like this: fact sales, dim product, dim country, dim store I am trying to achieve the following (mind you I have a composite model in my report with 2 DQ connections and I cannot use PowerQuery) I have a measure 'revenue'. Based on this measure I want to calculate a revenue share % for my products against the total revenue. Like: product A 20% product B 14% product C 0.4% This is achieved easily by a metric like: product revenue share % VAR total_revenue_fixed = calculate([revenue], REMOVEFILTERS(dim_product[product_name]) VAR revenue_product = [revenue] RETURN DIVIDE(revenue_product, total_revenue_fixedl) Now I want to add more complexity. When selecting a store from a report slicer, I want to see the product revenue share % for similar stores (say store group). The problem is that I need an average of my original product revenue share % per store group to show up per store id (mapped to a certain store group). So I need an average measure of an existing measure in a new context, which is of course not possible in PBI. I need to make sure that my store slicer(s) do not affect my original 'product revenue share %' and its components (like total revenue). How can I achieve this? I hope it's clear what I am asking.
Best product / partner for our use-case
Firstly, my apologies if this is in the wrong board (if so, and someone can move it, please do so). I'm looking for advice on the best PowerBI solution to meet our technical needs and possibly a recommendation on which Partner to work with in relation to deployment / implementation. Our business provides a Digital Work Instructions suite to a broad range of international clients. Our clients use our software to assist them in manufacturing processes and as a result, gather a large amount of process data which they would then like to analyse. Our end users range from power users with extensive DB and programming knowledge (who will want to design, build and modify reports) through to line-workers who just need to see a chart to let them know how the current run is progressing. Some clients have power users, some don't. All clients have basic users. We also need the ability for our staff to build a set of general reports that we can deploy to all clients. The sales / delivery model we use allows our clients to fall into one of three basic categories; cloud based (SaaS), on-premise (the majority of our client base currently) and finally on-premise secure (i.e. no external or internet access from our application server hosted on site). We need to provide the same level of analytics and reporting to all these clients and also to be able to deploy new reports to them all. For our on-premise secure clients we need a means by which we can package up and export / import new reports / dashboards to them (this doesn't need to be an integral feature, it just needs to be reasonably straightforward to do). We're based in the West Midlands in the UK but our clients are worldwide. I realise this is a potentially complex set of circumstances but if anyone can offer any advice / pointers, I'd be very grateful and if anyone has any questions, please ask! Thanks in advance, Andrew Flower Techincal Projects Manager: NoMuda Limited
