Forum Discussion

LadyCat's avatar
LadyCat
Frequent Visitor
3 years ago

Getting ALLSELECTED and IN To Work Together?

Hi All, 

 

I am fairly new to Power Bi and have a DAX question about how to make ALLSELECTED and IN work together.

 

Basically, I have data that looks like this: 

 

Product Table

Product Code  Value

1A

1B

1C

1D

1E

2A

2B

2C

2D

2E

 

In Power Bi, I put this table in a matrix with a filter on the "1" category.

 

I would like to calculate a simulated value based on some stress parameter in a slicer but only for selected products from the "1" category. The end result should appear in an aggregate form (such as a card) on my visual.

 

I have a measure that computes the total product value for selected products and that uses "ALLSELECTED": Value Selected Products = CALCULATE([Total Product Value], ALLSELECTED(Product Table[Product Code])).

 

I also have a slicer with the following measure: Stressed Value Products = CALCULATE([Value Selected Products]*(1 - Stress Value Product)/100))

 

Based on this, the user should be able to select individual products from the "1" category (all or a few), apply the stress in the slicer and get the stressed values for the selected products.

 

To do this, I am trying to write something like the following in Power Bi but it doesn't work: Stressed Value Selected Products = CALCULATE([Total Product Value], ALLSELECTED(Product Table[Product Code]) IN {"1A", "1B", "1C", "1D", "1E"}) and returns an error message (incorrect syntax). 

 

Is there a way to make ALLSELECTED and IN work together?

 

Any help will be greatly appreciated.

 

Thank you

 

2 Replies

  • KeyurPatel14's avatar
    KeyurPatel14
    Icon for Responsive Resident rankResponsive Resident

    Hi LadyCat ,
    I actually dont know what you want exactly but you can refer to the below measure if you want to work with ALLSELECTED and IN together.

    Test = 
    VAR selectedprodcode = ALLSELECTED(Product Table[Product Code])
    RETURN

    CALCULATE(

                        [Total Product Value],

                        FILTER(

                                   Product Table,Product Table[Product Code] IN selectedprodcode 

                        ),
    )

    • LadyCat's avatar
      LadyCat
      Frequent Visitor

      Hi,

       

      Thanks, I'll try this. Do you think there is an easier way to do this?

       

      Regards