Need help to write DAX to calculate cumulative sum

[MJALARI]

Hi,

I have a requirement  seats table which includes columns as location and seats

Location	Seats
Hyderabad	1000
Chennai	2000
Mumbai	3000

and utilization table which includes columns as location and percentage utilization

Location	Utilization perc
Hyderabad	0.75
chennai	0.62
Mumbai	0.79

I have common dimension of city which includes columns city

CITY

Hyderbad

Bangalore

Mumbai

Relationship between tables seat to city dimension and city to utilization  tables

Need to calculate irrespective of the city against (utilization perc) *( seats)  

 1000 * 0.75 = 750 

2000*0.62 = 1240

3000*0.79 = 2370

dax should return 750+1240 +2370 = 4360.

Note : i dont have city slicer.

Please help 

[Jihwan_Kim]

Hi, @MJALARI 

Thank you for your feedback.

Please check the below.

Expected Result Measure =
SUMX (
Seats,
Seats[Seats ]
* LOOKUPVALUE (
Utilization[Utilization perc],
Utilization[Location], RELATED ( Cities[City] )
)
)

https://www.dropbox.com/s/vjf2ucs7tjhzjac/mjalari.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[MJALARI]

Hi Jihwan ,

i dont have direct relationship between two tables , i have city dimension as intermediate. Apologies, missed to update

[Jihwan_Kim · Accepted solution]

Hi, @MJALARI 

I am not sure if I understood your question correctly, especially the part that you do not have a city slicer.

However, please check the below picture and the sample pbix file's link down below.

It is for creating a measure, not a column.

Expected Result Measure =
SUMX ( Seats, Seats[Seats ] * RELATED ( Utilization[Utilization perc] ) )

https://www.dropbox.com/s/vjf2ucs7tjhzjac/mjalari.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM