Apply discount to single product category,sub-category and keep the rest as is

[pratikg]

I have product category (say 10 unique), product sub-category(say 5 per category), product price. I have created slicer dropdown for the user to select a category and sub-category, and a what-if parameter to select a particular discount they want to apply. I want to calculate the discounted price as a column where the discount is to be applied to only to user selected category and sub-category, not all products. 

[Anonymous]

Hi @pratikg 

It will be easier if you provide some sample data (That can be copied and pasted).

Including the expected results, what was done, whats not working, etc.

Cheers!
A

[pratikg]

Hi @Anonymous ,

So consider 2 tables CloseCodes_Lookup connected to FinOps_Data (1:M) using a key. I want to find out Finops_Data[TTR_Hours]*(1-Improvement[Improvement Value]/100) for a specific L2 (a measure) and Finops_Data[TTR_Hours] for rest of L2 values.

TTR_Hr_Imp = 
VAR L2 = [Measure_L2]
RETURN
CALCULATE(SUMX(Finops_Data,Finops_Data[TTR_Hours]*(1-Improvement[Improvement Value]/100)),CloseCodes_Lookup[L2]=L2) << This L2 is a measure>>