Forum Discussion
Multiple Selection to put into different formula
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])))
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
1 Reply
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