Forum Discussion
Calculate each values in slicer selection
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.
Super UserHi 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?
- MFelix
Hi Decter3343 ,
In this case will you need to have a parameter for each of the vendors so in this case the 1000?
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
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.