Forum Discussion

Decter3343's avatar
Decter3343
Frequent Visitor
3 years ago
Solved

Calculate each values in slicer selection

Hi.   Let me explain current my concern.  please, find below picture.   there is two part. first, i select potential Vendor with slicer. if i select three vendors, i can find these vendors...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    So for this you want to pick up 5 vendors and apply to those the parameters correct?

     

    I assume you have a table for vendors (dimension and another with the fact tables and a measure that you are using to be changed. 

     

    Create the following measure:

    Total adjusted = 
VAR test =
    CALCULATE (
        COUNTROWS ( ALLSELECTED ( 'Vendors' ) ),
        FILTER (
            ALLSELECTED ( 'Vendors'[Vendor] ),
            'Vendors'[Vendor] <= MAX ( 'Vendors'[Vendor] )
        )
    )
RETURN
    SWITCH (
        test,
        1, [Total Sales]+ [Vendor1 Parameter Value],
        2, [Total Sales] + [Vendor 2 Parameter Value],
       [Total Sales]
    )

     

    In this case I only have two but you can have 5 or more:

     

    Check PBIX file attach.

     

Decter3343's avatar
Decter3343
Frequent Visitor
3 years ago

Thanks for your kind explanation.  hope you understand that most of words are written by Korean in captured picture

 

As per your advice, i made it using "SWITCH"

In Dax Function "SWITCH", I put the "A company" and "B company" Condition with Parameter1, 2

and it works. if i change parameter1, score of A company only changed. and If i change parameter2, score of B company only chagned. 

 

However, there is another problem. basically, in the "SWITCH" Fuction, all of vendor condition should be written. but number of Vendors are almost 1,000. it is not possible to write all of vendor in the SWITCH for condition. 

 

is there any other way to write condition more easily? 

 

 

 

 

 

 

MFelix's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

Hi Decter3343 ,

 

In this case will you need to have a parameter for each of the vendors so in this case the 1000?

  • Decter3343's avatar
    Decter3343
    Frequent Visitor
    3 years ago

    Parameter is only for selected Vendors in slicer. 
    in my case, maximum number of selected vendor is Five. 

    therefore, only 5 parameter is required. 

     

    but in slicer, there is almost 1,000 number of vendor is listed. 

     

    below list is my work process

     

    1. select potential vendor in the slicer (maximum 5)

    2. selected vendor is listed in the table. 

    3. most of scores are counted automatically.

    4. addtional score will be added using parameter.

    • MFelix's avatar
      MFelix
      Icon for Super User rankSuper User
      3 years ago

      So for this you want to pick up 5 vendors and apply to those the parameters correct?

       

      I assume you have a table for vendors (dimension and another with the fact tables and a measure that you are using to be changed. 

       

      Create the following measure:

      Total adjusted = 
VAR test =
    CALCULATE (
        COUNTROWS ( ALLSELECTED ( 'Vendors' ) ),
        FILTER (
            ALLSELECTED ( 'Vendors'[Vendor] ),
            'Vendors'[Vendor] <= MAX ( 'Vendors'[Vendor] )
        )
    )
RETURN
    SWITCH (
        test,
        1, [Total Sales]+ [Vendor1 Parameter Value],
        2, [Total Sales] + [Vendor 2 Parameter Value],
       [Total Sales]
    )

       

      In this case I only have two but you can have 5 or more:

       

      Check PBIX file attach.

       

      • Decter3343's avatar
        Decter3343
        Frequent Visitor
        3 years ago

        Thank you so much. it's exactly what i want.

        I couldn't have dont it without your help. You are literally a super user.

        Once again, thanks you very much.