Measure to get a difference of row value from a column total

[tabish]

https://drive.google.com/file/d/1MKNxxfU5nuhIBZvwR8BWePVF2QAJOosh/view?usp=sharing 

plz see the attached link to the dummy data with expected result

I have measures which calculate the distinct count  

CALCULATE(DISTINCTCOUNT([Brand]), FILTER([Chnl] = "AN" || [Chnl] = "GN" || [Chnl] = "DN" || [Chnl] = "EN" || [Chnl] = "SN"))

i need to get a difference from the column total for each row.

chn group(AN,GN,DN,EN,SN)	unique count (Active brands)	result (inactive brands)
AN	192	341-192=149
GN	241	341-241=100
DN	212	341-212=129
EN	139	341-139=202
SM	140	341-140=202
other
Total	315

[amitchandak · Accepted solution]

@tabish , Diff from total measure

diff =CALCULATE(DISTINCTCOUNT([Brand]), FILTER(allselected(Table),[Chnl] in{ "AN" ,"GN" ,"DN" , "EN" , "SN"}) ) -

CALCULATE(DISTINCTCOUNT([Brand]), FILTER(Table,[Chnl] in{ "AN" ,"GN" ,"DN" , "EN" , "SN"}))

[tabish]

@amitchandak 

Thanks a lot, cheers!