Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
NataliaLM
New Member

Create Slicer Based on Measure Value

I would like to create slicer based on "ABC" Measure:

NataliaLM_1-1696589061742.png

 



I fave following data table:

NataliaLM_0-1696588727775.png


And following Measures:

Total Sales = SUM(Sales[Sales])

Cumulative % =
VAR thisProductSales = [Total Sales] /* this sets the margin for the current product  */
VAR TotalSalesAllProducts =
    CALCULATE([Total Sales], ALL(Sales[Product])) /* the total sales across all products. */
RETURN
    CALCULATE(
        [Total Sales],
        FILTER(ALL(Sales[Product]), [Total Sales] <= thisProductSales)
    ) / TotalSalesAllProducts

ABC = if([Cumulative %]<0.2,"B","A")

And I'm getting folloeing Matrix with Cumulative Sales %:
NataliaLM_2-1696589201973.png


ABC Column for the same SKU may have different letter, depends which Shop/Shops I am filterring.

How to create slicer based in "ABC" measure?

 

 

3 REPLIES 3
NataliaLM
New Member

I cannot create conditional column, because the value is different depends the filters used by user.
Generally I need calculate "Sales" (and different parameters) for "A" products, so products with cumulative sales (20%-100%).
Cumulative sales may be different for the same product, depends the filter the user uses.

Measure can not be used in slicer but this measure can be put in a table visual with this being the only column and still not being an actual slicer can work as a filter on the basis of interactions.

ChiragGarg2512
Solution Sage
Solution Sage

@NataliaLM Slicer can not work with measure. Create a conditional column with the help of the same dax formula and use that column in slicer.

Thank You.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.