Forum Discussion

sachinnamdeo798's avatar
sachinnamdeo798
Frequent Visitor
3 years ago

Slicing value with Percentage selection

Dear community
"I Want to slice dealer  achivemnt sales with percentage slicer in scale of  0 to 100 % ".
I have data as like this image
 I have a table name of  Cube_ invoice in which 
Sold to partner code is dealer code and name is dealer name column
invoice quantity cloumn 

target quantity cloumn 
 i calculate tagrget achived% of dealer with this measure 

 

Target Achieved % = DIVIDE( SUM(CUBE_INVOICE[INVOICE QUANTITY]), SUM(CUBE_TARGET[TARGET QUANTITY]) )

 


Now i want to create a slicer of percentge in scale of  0 to 100 % , which satisfying this condition if i select 0 to 20 % in slicer it should only return of those dealer name and their sales which has acheived thieir 20% sales not return all the value.
 

Please help

2 Replies