Forum Discussion

shantupm5's avatar
shantupm5
Icon for Helper III rankHelper III
2 years ago
Solved

Total in % for each region Split

Here is my raw data   Region Region Vol Split AMERICAS 21% APAC 79% AMERICAS 71.0% APAC 9.0% EMEA 20.0% EMEA 10% APAC 55% EMEA ...
Need Help
Show and Tell
Tips and Tricks
  • Dangar332's avatar
    Dangar332
    2 years ago

    hi, shantupm5 

     

    try below

    result =
var a = sum('tablename'[region vol split])
var b = calculate(sum('tablename'[region vol split]),removefilters('tablename'[region]))
 return
divide(a,b)
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, shantupm5 

 

try below

result =
var a = sum('tablename'[region vol split])
var b = calculate(sum('tablename'[region vol split]),removefilters('tablename'[region]))
 return
divide(a,b)
  • shantupm5's avatar
    shantupm5
    Icon for Helper III rankHelper III
    2 years ago

    You are amazning! Thank you so much 🙂