Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
I have measure which calculates cumulative (12 month) of sales for a city -- and, I have the population for that city in a separate table ["Demographics"]. Trying to create a measure which divides the cumulative sales by the city's population so I can get a per person sales figure.
Thank you! ~AGS
Thanks for reaching out to us.
Try this, (supposing the name of your measure is measure1)
(1) create a table visual, and put city field from Sales into it
(2) create the measure and put it into table visual
SalesPerPerson=
var _population = CALCULATE(MAX(Demographics[population]),Demographics[city]=MAX(Sales[city]))
return [measure1]/_population
If this doesn't help, then you may need to make small changes to your measure,
Could you share
(1) measure which calculates cumulative (12 month) of sales for a city
(2.1) a sample file
(2.2) or post some sample data in text, e.g.
Sales
date | city | sales |
2021/1/1 | city1 | 1 |
2021/2/1 | city2 | 2 |
? | ? | ? |
? | ? | ? |
Demographics
city | population |
city1 | 2 |
city2 | 3 |
(3) expected result
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Thank you!
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
77 | |
73 | |
71 | |
45 | |
42 |
User | Count |
---|---|
48 | |
47 | |
29 | |
28 | |
28 |