Forum Discussion
Two Slicers with User defined value
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.
4 Replies
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)
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
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
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:
- Create a calculated table like this:
Slicer = GENERATESERIES(1,999999999,1)Slicer2 = GENERATESERIES(1,999999999,1)- Create a relationship between the two tables:
- 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.
