Forum Discussion

ktt777's avatar
ktt777
Helper V
6 years ago
Solved

Overall value in matrix/table

Here is my raw data :

 

LocationRentOwned 
West11
North28
South19
East13
Total521

 

How can i create a matrix or table with below data

LocationRental Ratio 
West50%
North20%
South10%
East25%
Total 19.23%

 

I want to get the total equal to total rental/(total rental+total owned) ,instead of taking average of rental ratio 

 

thanks

Need Help
  • Tahreem24's avatar
    Tahreem24
    6 years ago

    ktt777 ,

    Try the below Measure DAX:

    Measure 2 = sum(Table[Rent])/(SUM(Table[Rent])+sum(Table[Owned ]))

2 Replies

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    ktt777 ,

    Try the below Measure DAX:

    Measure 2 = sum(Table[Rent])/(SUM(Table[Rent])+sum(Table[Owned ]))