Calculation with Slicer selection.

Question

Hi.&nbsp;below is my request. i have been tried several way. but it was not working.&nbsp;&nbsp;1.&nbsp;Table1&nbsp;has&nbsp;dozens&nbsp;of&nbsp;product&nbsp;name&nbsp;columns&nbsp;like&nbsp;A,&nbsp;B,&nbsp;C,&nbsp;and&nbsp;D.&nbsp;And&nbsp;there&nbsp;is&nbsp;a&nbsp;column the&nbsp; region of production&nbsp;2. I will Select&nbsp;Region&nbsp;for&nbsp;Slicer1.3.&nbsp;When&nbsp;I&nbsp;select&nbsp;a&nbsp;specific&nbsp;product&nbsp;in&nbsp;Slicer1,&nbsp;I&nbsp;want&nbsp;to&nbsp;assign&nbsp;10&nbsp;points&nbsp;to&nbsp;that&nbsp;product&nbsp;and&nbsp;5&nbsp;points&nbsp;to&nbsp;the&nbsp;others.4. i will show point status in the chart.I&nbsp;can't&nbsp;implement&nbsp;it&nbsp;well&nbsp;with&nbsp;the&nbsp;if&nbsp;function.&nbsp;If&nbsp;there&nbsp;is&nbsp;a&nbsp;way,&nbsp;I'd&nbsp;appreciate&nbsp;it&nbsp;if&nbsp;you&nbsp;let&nbsp;me&nbsp;know.thanks in advanced

manokamna · Accepted Answer

Create a new measure using Swtich&nbsp;

Forum Discussion

Calculation with Slicer selection.

2 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Between date slicer - calender selection

Quarter calculation upto selected month