Creating a basket of products in power BI

[Feerthoven]

Hello Team,

I am working in Power Bi and my goal is to be able to pick a certain number of products (creating a basket)  with different quantities each to see the total cost of the whole basket.

Would you guide me how to tackle that?

Thanks,

Fernando

[DaleT]

Hi Fernando,

It depends. If the number of products is not large, it's possible. The products could be in a slicer in which you can make multi-selection. Each quantity is a slicer because you want to make it dynamic. Then the calculation is in a measure. 

Dale

[Feerthoven]

Hi Dale,

How the calculation would be?

Could you provide an example please?

Regards,

Fernando

[DaleT]

Hi Fernando,

Please refer to the demo here https://drive.google.com/file/d/1aaUjyZHMoah6zXoXPXbYifBdIpCulsth/view?usp=sharing

I hope it helps. 

Dale

[Feerthoven]

Hello Dale,

Looking at your example, it works perfectly for a predefined table but how should be done in case we keep adding products every once in a while (like merging new files monthly)?

Thanks again,

Fernando

[v-linyulu-msft]

Can you tell me if your problem is solved? If yes, please accept DaleT 's and lbendlin 'sreply as solution.

If you have already solved it yourself,share your solution and accept it as a solution that will help other community members who have the same problem as you.

Best Regards,

Leroy Lu

[lbendlin]

As I mentioned this is not supported in Power BI.  You need to know beforehand what buckets you want and how big they should be.

[DaleT]

Hi lbendlin,

Yes, this is only a workaround. Not perfect, but it works. 

Hi Fernando,

Try out this new version, please. It's hard to make the slicer to be single-select, so there will be a warning when multi-select happens.

https://drive.google.com/file/d/11gW7atA2e1trMuGtcPDnIQ8dfm4w9x-J/view?usp=sharing 

Dale

[Feerthoven]

Would be dynamic baskets based on a table (of products) already uploaded in Power Bi.

Should be able to do it in Power Bi or I need to combinde Power Apps as well?

[lbendlin]

A dynamic basket would be something like the Tableau LOD feature

Level of Detail Expressions - Tableau

As I mentioned this is not supported in Power BI.  You need to know beforehand what buckets you want and how big they should be.

[lbendlin]

Are your baskets predefined or are you thinking of creating dynamic baskets?  (Hint: not supported in Power BI)