Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a dataset which lists sales by Franchisee over different periods of time. It is also separated by type of sale, but I have left this out for simplicity. So, for example:
Franchisee Period Sales A Month to Date $100 B Month to Date $200 A Year to Date $1000 B Year to Date $2000
I want to create a Lorenz curve to show the distribution of sales per Franchisee. I want to be able to select the period over which the curve will calculate using a slicer (e.g. the curve for the "Month to Date" may be different to the curve for the "Year to Date').
In order to do this, I need to filter the data by Franchisee (using a slicer preferably) and then calculate the cumulative sum of all Franchisee's. So for example, for the "Month to Date", I need the following:
Franchisee Sales Cumulative Sales B $200 $200
A $100 $300
I have tried a number of different possibilities based on other answers in this forum, but I just can't seem to get it right.
Any help would be greatly appreciated.
Thank you in advance!
Hi @daniBBB
Could you please share your dummy pbix or simple worksheet? that would be easier for us to replicate your data.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |