Two Slicers with User defined value

[Anonymous]

Hi,

I have two slicers. One slicer is SUM(A) and the other one is SUM(B)

What i want is to filter using the condition

SUM(A) > Userenteredvalue OR SUM(B) > UserEnteredvalue2

I want two values which the user of the dashboard will be able to input. If it's not possible i can use the greater than slicer option but still want the user selected value in the slicer to be taken in the expression.

[v-robertq-msft]

Hi, @Anonymous 

According to your description, I think you can use the GENERATESERIES() function in DAX to create two new calculated tables in custom to place into a vale range slicer to slice the data, you can try my steps:

1. Create a calculated table like this:

Slicer = GENERATESERIES(1,999999999,1)

Slicer2 = GENERATESERIES(1,999999999,1)

2. Create a relationship between the two tables:

3. Create a slicer to slice the data table, then you can try if the function can work in the big data condition

More info about the GENERATESERIES() function in DAX

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@Anonymous , I think you can use what if the parameter for that

measure =

var _val = maxx(allselected(whatif), whatid[param])

return

sumx(values(Table[id]) , if(sum(Table[A]) >_val, Sum(Table[A]),0))

you need to group data at a level to filter measure (values, id)

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

[Anonymous]

Thank you for the response, however I am quite new to powerbi.

I saw the whatif parameter but it only allows values upto 9999. My numbers can go in billions since it is a amount i am dealing with.

So lets say the range of a particular value lies from 0 to 999,999,999

and i want sum of only those values which lie above 100,000  it doesn't seem to work.

Can you guide me if at all possible

[amitchandak]

@Anonymous , you can use generate series and create manual parameter. but equal to value is only available with what if

https://docs.microsoft.com/en-us/dax/generateseries-function