Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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. Ho...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

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