Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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 November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.