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
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi samc_26 ,

Here are some steps that I want to share, you can check them if they suitable for your requirement.

Here is my test data:

1.Create two measures

 

Total with Discount = 
SUMX(
    'Table',
    IF(
        'Table'[Name] = "Charlie",
        'Table'[Charge] * 0.5,
        'Table'[Charge]
    )
)
Measure = 
IF(
    ISINSCOPE('Table'[Name]),
    sum('Table'[Charge]),
    [Total with Discount])

 

2.Final Output

Best Regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

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

Hi Albert, thank you for the ideas but it's not really had any effect on the data, i'm not sure if it's because I've got multiple weeks on my data or if it's something else? I can't really show you anything as it's business confidential 😞