topic Re: Slicing value with Percentage selection in DAX Commands and Tips

Slicing value with Percentage selection

sachinnamdeo798 — Wed, 03 May 2023 05:11:04 GMT

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

Re: Slicing value with Percentage selection

lbendlin — Sun, 30 Apr 2023 19:00:39 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Slicing value with Percentage selection

sachinnamdeo798 — Mon, 01 May 2023 04:30:20 GMT

Thank you sir for your suggestion