Slicer as Calculator

[damian_bell]

A somewhat self-referencing question here!

There is a PowerBI cost calculator here. 

It is a webpage rather than a PowerBi report but I would like to perform the same functions within PBI. 
My use case is obviously different but the key similarity is generating a cost based on varying proportions of a 'whole'. 
In the example above the two sliders can be independently set anywhere along the slicer and that changes the number of Pro, Frequent and Occasional Users. I can set up a simple slicer but how can I get it to simultaneously adjust 3 parameters? 
I can probably get the cost total on the right of the screenshot to work but the slicer setup has me baffled - any help gratefully received!

Thank you

[damian_bell]

This is *exactly* what I needed! Thank you so much, it would have taken me many frustrating hours to get even close to working this out. Now I see your solution I can see that it isn't too complicated but I have learnt a lot as I have played with this today. I am very grateful for your help. Thank you. 

[v-rzhou-msft · Accepted solution]

Hi @damian_bell 

You could try to build a slicer table as below.

Percentage Slicer = GENERATESERIES(0, 1, 0.0001)

Build a slicer by between and slicer is as below.

I build a User table.

Measure:

Percent User = 
VAR _Total_User = 5000
VAR _PercentUser1 =
    MIN ( 'Percentage Slicer'[Percentage Slicer] )
VAR _PercentUser2 =
    MAX ( 'Percentage Slicer'[Percentage Slicer] ) - _PercentUser1
VAR _PercentUser3 =
    1 - MAX ( 'Percentage Slicer'[Percentage Slicer] )
RETURN
    SWITCH (
        TRUE (),
        MAX ( User[User] ) = "User1",
            FORMAT ( _PercentUser1 * _Total_User, "0" ) & "     "
                & FORMAT ( _PercentUser1, "(0.00%)" ),
        MAX ( User[User] ) = "User2",
            FORMAT ( _PercentUser2 * _Total_User, "0" ) & "     "
                & FORMAT ( _PercentUser2, "(0.00%)" ),
        FORMAT ( _PercentUser3 * _Total_User, "0" ) & "     "
            & FORMAT ( _PercentUser3, "(0.00%)" )
    )

TotalPrice = 
VAR _Total_User = 5000
VAR _PercentUser1 =
    MIN ( 'Percentage Slicer'[Percentage Slicer] )
VAR _PercentUser2 =
    MAX ( 'Percentage Slicer'[Percentage Slicer] ) - _PercentUser1
VAR _PercentUser3 =
    1 - MAX ( 'Percentage Slicer'[Percentage Slicer] )
VAR _NumUser1 = _PercentUser1*_Total_User
VAR _NumUser2 = _PercentUser2*_Total_User
VAR _NumUser3 = _PercentUser3*_Total_User
VAR _TotalPrice = _NumUser1*100+_NumUser2*200+_NumUser3*50
RETURN
_TotalPrice

Result is as below.

You can download the pbix file from this link: File

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.