The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I would like to create slicer based on "ABC" Measure:
I fave following data table:
And following Measures:
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?
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.
@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.