Customizable slab wise data

[Anonymous]

Hello,

I want to create a slab wise sales table where the size of the slabs is customizable.

Example – Suppose I have a data table with InvoiceID, Sales Qty, and Free Qty.

I want to create a slab wise sales table where users can change the slab sizes and see the results easily.

Hope I have explained my requirement correctly.

Thanks

 

[amitchandak · Accepted solution]

@Anonymous , In case you need that at row values

Create a column like this and use it

switch( True()
[sales qty] <10 , " <10",
[sales qty] <100 , " 10 -99 ",
// Add others
)

https://www.daxpatterns.com/static-segmentation/

In case it is on sum(sales qty), then you need to create an independent bucket table and create a measure that falls in the bucket. refer

https://www.daxpatterns.com/dynamic-segmentation/