Measure Range Calculation

kavirao — Tue, 30 Nov 2021 16:25:32 GMT

I do have use case where I need to generate a report based on 2 custom variable selection.

I am calculating the sum of sales based on 2 selections which are variable input not a dimentions

1) Sales Type - options are (Direct , Indirect , Others) based on selection it will calculate sum

sum(if($(vsaletype) =1 , Direct , if($(vsaletype) = 2, indirect , others)))

2)Sales Range - Options are ( < 100000 , > 100000 , 100000 - 1000000, 1000000 -2000000,2000000-3000000)

I need to include this range into after calculate sum of sales using salestype.

Let me know any solutions on this

Thank you

Kavitha

topic Measure Range Calculation in App Development