Forum Discussion

samc_26's avatar
samc_26
Icon for Helper IV rankHelper IV
2 years ago

Row level filter with calculation

Hi all, I have a table with a list of costs against different people but for one person I want to give them a 50% discount, in this case I'll use Charlie as the chosen one! So I want the £200 to stay...
Need Help
Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, samc_26 

 

 

Measure = 
var b = SUMX(  FILTER( 'Table' ,'Table'[name]="charlie"),'Table'[charge])
var c = b* (50/100)
var d = CALCULATE(SUM('Table'[charge]),ALL())
return
IF(ISINSCOPE('Table'[name]),MIN('Table'[charge]),d-c)