Forum Discussion
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 information with table. in this table, there is vendor information with score and last column is total number of score. there is no problem so far.
but problem is second part. each of vendor could have additional score.
its rule is not exist and it can be added base on judgement of person in charge.
Is it possible to add each different additional score in parameters to each vendor selected in slicer?
i try to make array with selected vendor. but it doesn't work. and i also try to make new table with selected vendor. but it also does not work.
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.
6 Replies
Hi Decter3343 ,
Not sure if I understand your question correctly but if you want to have additional values based on parameters for each vendor, you need to create a parameter table for each of your vendors then using the selected value has you were refering you can make the calculation of the new score.
The syntax for the new score would be similar to this:
New Score = SWITCH (SELECTEDVALUE(Table[Vendor]), 1 , [Total Score] + [Parameter 1 value], 2 , [Total Score] + [Parameter 2 value], 3 , [Total Score] + [Parameter 3 value], [Total Score])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?
Hi Decter3343 ,
In this case will you need to have a parameter for each of the vendors so in this case the 1000?
