Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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 valu...
Need Help
Show and Tell
v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

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)
  1. Create a relationship between the two tables:

 

  1. 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.