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
samc_26's avatar
samc_26
Icon for Helper IV rankHelper IV
2 years ago

Hi, thank you for taking the time to post this, I have tried to use it but I can't work out how the code filters to just the name 'Charlie'? When I put the measure in a card it shows a figure of 2.89M when I'm looking for about 11k so not sure what's happened! 

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

hi, samc_26 

 

i made code for dynamic user selection 

for only charlie

try below code 

 

Measure = 
var b = SUMX(  FILTER( 'Table (3)' ,'Table (3)'[name]="charlie"),'Table (3)'[charge])
var c = b* (50/100)
var d = CALCULATE(SUM('Table (3)'[charge]),ALL())
return
IF(ISINSCOPE('Table (3)'[name]),MIN('Table (3)'[charge]),d-c)
  • samc_26's avatar
    samc_26
    Icon for Helper IV rankHelper IV
    2 years ago

    Hi Dangar332 I've tried this but it's still not working 😞 Thank you again for your suggestions!