Slicer for a measure

[LaurenceSD]

Hi,

Wondering if what I'm wanting to do is possible.

Set up is, a table full of bookings (many), which links (one to many) to a table full of customers (one) and a date table (one).

I've then got a measure of number of customers (countrows), number of bookings (countrows) and TTV (sum).

What my end user wants to do use slicers to filter the customers by booking date (for example in the last year or last 2 years) and by number of bookings and TTV in that period. Without using the filters, is there a way of doing this with a slicers so the end user can see how many guests made 2 or more bookings and spent £10k or more? Or is the only way to use the visual filters, meaning I'm restricted to 1 visual or have to explain to end user to change the filter on each visual

Thanks 

[AmiraBedh]

Mainly, you have 2 alternatives in your case :

•  Create a calculated table that aggregates bookings and TTV by customer and by period

• Create measures that dynamically calculate the count of customers, bookings, and TTV based on the selected slicer values

Another approach is to use parameter tables as slicers, which can control the values of the measures based on user selection.

[LaurenceSD]

Thanks @AmiraBedh do have a guide on either method? I did start trying to go down the Parameters route, but I got stumped on how to link it to a measure.

With the calculated column route, how can I factor in the use of a date slicer into this? Or would i have to provide a fixed period, that the end user can't adjust?

Thanks

[AmiraBedh]

Yes if you share your data/model 😄

[LaurenceSD]

Heres a link to my data model https://drive.google.com/file/d/1HyWectLiAuPh5xOJ_NDHkYFW_z92yu6v/view?usp=drive_link

[v-jianpeng-msft]

Hi, @LaurenceSD 

Thanks @AmiraBedh . Has your issue been resolved? I can't open the link you shared, can you share it on OneDrive? Please be careful not to include any private data.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

[AmiraBedh]

I requested acces. Can you reshare your data ?

[LaurenceSD]

Thanks, yes you should have access now

[LaurenceSD]

Thank you - I'll anonymise it and send it over