Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |