Forum Discussion
dax help with division
hi community I need to ask for your help, i have to find out what the spend per passenger is o my most recent project. I know i need a new calculated column but i dont know how to make the da...
What you likely want are measures, not calculated columns. So, in the first example, you could create a measure like:
SpendPerPassenger = SUM([Spend]) / SUM([Passengers])
If you put this measure into your visual, it will be evaluated in context, which means within the context of each row.
For the rest of it, sample data would help but this should get you started down the right path.
thank you ,
I'll give that a go and let you know
Hi ecs70206,
Could you please tell me if your problem was resolved? Could you please share the answer or mark the proper answer as solution if it's convenient for you? That will be a help to the others.
Best Regards!
Dale
