cancel
Showing results for
Did you mean:
Helper I

## create slice

Hello,

I have this table and I would like to create a slicer for an average of LAR . So if  the average LAR is "greater than 96%" and "less than 96%"

Thank you.

1 ACCEPTED SOLUTION
Community Support

Hi @gio1082 ,

Based on your desricption, I have defined the [Average of LAR] as a measure in my sample file like this:

``Average = AVERAGE('Table'[Average of LAR])``

Modified the previous measure:

``````Measure =
IF (
NOT ( ISFILTERED ( 'Slicer table'[LAR slicer] ) ),
1,
IF (
SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "greater than 96%",
IF ( [Average] > 0.96, 1 ),
IF (
SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "less than 96%",
IF ( [Average] < 0.96, 1 )
)
)
)``````

Refer the sample file: Create a slicer.pbix

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

4 REPLIES 4
Community Support

Hi @gio1082 ,

1. Create this table manually first:

2. Create a measure like this, put it in the visual table and set its vallue as 1:

``````Measure =
IF (
SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "greater than 96%",
IF ( SELECTEDVALUE ( 'Table'[Average of LAR] ) > 0.96, 1 ),
IF (
SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "less than 96%",
IF ( SELECTEDVALUE ( 'Table'[Average of LAR] ) < 0.96, 1 )
)
)``````

Attached sample file that hopes to help you: create a slicer.pbix

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Helper I

Hi,

Sorry, for late response, this definitely what want but it not working for me. I think is because the average of LAR is metric.

So I have some products and a supplier who is responsible for that product. So Average LAR is a metric of the LAR to get the average for the supplier base on the products

thanks

Community Support

Hi @gio1082 ,

Based on your desricption, I have defined the [Average of LAR] as a measure in my sample file like this:

``Average = AVERAGE('Table'[Average of LAR])``

Modified the previous measure:

``````Measure =
IF (
NOT ( ISFILTERED ( 'Slicer table'[LAR slicer] ) ),
1,
IF (
SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "greater than 96%",
IF ( [Average] > 0.96, 1 ),
IF (
SELECTEDVALUE ( 'Slicer table'[LAR slicer] ) = "less than 96%",
IF ( [Average] < 0.96, 1 )
)
)
)``````

Refer the sample file: Create a slicer.pbix

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Super User IV

---------------------------------------

@ me in replies or I'll lose your thread!!!

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!