Multiple Selection to put into different formula

[Anonymous]

Hi guys,

Based on this picture, If I selected the Brand1 will apply to this formula, but I want the first I select is going to the first formula, secondly select will go to the second formula. How should I do? Is that possible to do this? Actually, this formula is not the actual formula this is the just simple formula I just want to ask how to fill only. How can help me? Is that clear my question? 

Many = 1) CALCULATE(SUM(Data[Price]),FILTER(Data,Data[Brand]=VALUEs(Brand[Brand1]))) + 
       2) CALCULATE(SUM(Data[Price]),FILTER(Data,Data[Brand]=VALUEs(Brand[Brand1])))

[v-yuta-msft · Accepted solution]

Hi AlbisLoke,

PBI can’t recognize which item is the first selected item in a slicer. As a workaround, if you want to sum up Data[Price] only based on rows in filter, you can simply use DAX formula:

Many = CALCULATE(SUM(Data[Price]), FILTER(Data, Data[Brand] =  “AFFLIGEM”)) +

CALCULATE(SUM(Data[Price]), FILTER(Data, Data[Brand] = “ANCHOR SD”))

if you want to sum up Data[Price] based on all of the selected item in slicer. you can use DAX formula below:

Many = IF(ISFILTERED(Brand[Brand1]), CALCULATE(SUM(Data[Price]), ALLSELECTED(Brand[Brand1])), BLANK())

PBIX file here:

https://www.dropbox.com/s/ntc2fr33rs8i2lt/For%20AlbisLoke.pbix?dl=0

Regards,

Jimmy Tao