Create a formula with a filter like an "included" value to display

[LD1]

Hi everyone, 

I have a question to submit to you !

Is it possible to keep the total of the first line (360) and diplay only the second field's value "Lights" but not "Other" like an "Included" => Below is the explication now & then

I mean, is is possible to make a filter with a substraction of the total minus all data but to keep the "Lights" data? 

Thank you in advance for your return and have a good day !

Léna

[LD1]

Hi @Mahesh0016 , sorry i can't send you the dataset because of confidentiality but i have tried to explain you the issue simpler below. Hope I am clear this time :

Thank you so much, 

[Mahesh0016]

@LD1 

Total Amount =

SUM ( 'Table X'[Amount] )

##########################

Final Amount =

IF(SELECTEDVALUE('Table X'[Category])="Others",BLANK(),[Total Amount])

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

[Mahesh0016]

@LD1 Please Share Your Demo dataset for better Understanding.THANK YOU!!